> For the complete documentation index, see [llms.txt](https://docs.keyfax.biz/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.keyfax.biz/product-suite/admin/databox-expressions/date-expressions/asdate.md). # AsDate The `AsDate` expression can be used in many ways to format a date held in [Databoxes](/product-suite/admin/entities/databoxes.md) . A comprehensive list of format specifiers follows:
ExpressionDatabox ValueResultComments
AsDate15-10-2018 08:00pm15/10/2018 20:00:00A date entry is converted into a simple date format
AsDate Format ("ddd dd MMM yyyy - HH:mm")15-10-2018 08:00pmMon 15 Oct 2018 - 20:00A date entry is formatted to the required layout
AsDate Format (‘d’)15-10-2018 08:00pm15/10/2018A date entry is converted into day/month/year
AsDate Format (‘dd’)15-10-2018 08:00pm15 A date entry is converted into day of the month
AsDate Format (‘ddd’)15-10-2018 08:00pmMonA date entry is converted into short name for day
AsDate Format (‘dddd’)15-10-2018 08:00pmMondayA date entry is converted into full name for day
AsDate Format (‘D’)15-10-2018 08:00pm15 Oct 2018A date entry is converted into day month year (with short month name)
AsDate Format (‘m')15-10-2018 08:00pm15 OctA date entry is converted into day month (with short month name)
AsDate Format (‘mm')15-10-2018 08:00pm00 (minutes)A date entry is converted into the minutes past the hour
AsDate Format (‘MM’)15-10-2018 08:00pm10A date entry is converted into the month
AsDate Format (‘MMM’)15-10-2018 08:00pmOctA date entry is converted into the month (with short month name)
AsDate Format (‘y’)15-10-2018 08:00pmOct 2018A date entry is converted into month year (with short month name)
AsDate Format (‘yy’)15-10-2018 08:00pm18A date entry is converted into final two numbers of the year
AsDate Format (‘yyy’)15-10-2018 08:00pm2018A date entry is converted into the year
AsDate BetweenDates(DateAdd(Today, -1, 'yyyy'), Today)2021-06-17 08:00:00ZBooleanAsDate can be combined with other Expressions. This example determines if the databox's date value falls within the last year, returning a boolean True or False value.
### Example 1 Convert a [Company Data](/product-suite/admin/entities/databoxes/company-data.md) Databox value to a date. Databox CompanyData.Expressions.Date holds the value 15-10-2016 and using Examples.Date.AsDate in the message Expressions.EXPDATE it is converted into the format "ddd dd MMM yyyy". This is shown below\...
The fixed value to be converted. In example 2 below we demonstrate a more useful conversion on a user supplied value.
This is the expression to convert it to a different format. Using the correct formats you can convert this date into almost any formats. Please see the table above for a complete list of format specifiers.
The message applies the expression and displays it as seen below.
### Example 2 Convert a user entered date. This example follows the same format as the first but using a date entered by the user rather than a [Company Data](/product-suite/admin/entities/databoxes/company-data.md) Databox.
Today's date is added for this example and the message displays this in same format as in the example above.
### Example 3 Convert 24 hour time to 12 hour time. User enters time in the 24 hour format **"HH:mm"** and it is converted into and displayed as 12 hour time **"hh:mm tt"**
The user enters the time in question Time01, this is written into Examples.Date and then evaluated against Examples.Date.AsDate 24H->12H, the result is written into Script.Info01 and displayed in the message Expressions.EXPDATE08
Below the script has been run twice, once with an PM time and once with a AM time.