# 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:

Expression	Databox Value	Result	Comments
`AsDate`	15-10-2018 08:00pm	15/10/2018 20:00:00	A date entry is converted into a simple date format
`AsDate Format ("ddd dd MMM yyyy - HH:mm")`	15-10-2018 08:00pm	Mon 15 Oct 2018 - 20:00	A date entry is formatted to the required layout
`AsDate Format (‘d’)`	15-10-2018 08:00pm	15/10/2018	A date entry is converted into day/month/year
`AsDate Format (‘dd’)`	15-10-2018 08:00pm	15	A date entry is converted into day of the month
`AsDate Format (‘ddd’)`	15-10-2018 08:00pm	Mon	A date entry is converted into short name for day
`AsDate Format (‘dddd’)`	15-10-2018 08:00pm	Monday	A date entry is converted into full name for day
`AsDate Format (‘D’)`	15-10-2018 08:00pm	15 Oct 2018	A date entry is converted into day month year (with short month name)
`AsDate Format (‘m')`	15-10-2018 08:00pm	15 Oct	A date entry is converted into day month (with short month name)
`AsDate Format (‘mm')`	15-10-2018 08:00pm	00 (minutes)	A date entry is converted into the minutes past the hour
`AsDate Format (‘MM’)`	15-10-2018 08:00pm	10	A date entry is converted into the month
`AsDate Format (‘MMM’)`	15-10-2018 08:00pm	Oct	A date entry is converted into the month (with short month name)
`AsDate Format (‘y’)`	15-10-2018 08:00pm	Oct 2018	A date entry is converted into month year (with short month name)
`AsDate Format (‘yy’)`	15-10-2018 08:00pm	18	A date entry is converted into final two numbers of the year
`AsDate Format (‘yyy’)`	15-10-2018 08:00pm	2018	A date entry is converted into the year
`AsDate BetweenDates(DateAdd(Today, -1, 'yyyy'), Today)`	2021-06-17 08:00:00Z	Boolean	AsDate 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.

--- # Agent Instructions: Querying This Documentation If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question. Perform an HTTP GET request on the current page URL with the `ask` query parameter: ``` GET https://docs.keyfax.biz/product-suite/admin/databox-expressions/date-expressions/asdate.md?ask= ``` The question should be specific, self-contained, and written in natural language. The response will contain a direct answer to the question and relevant excerpts and sources from the documentation. Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.