Search…
Resources
Related Links
date
To convert to or return a date value
This function extracts the date from a timestamp field. It also returns a valid date from numeric values for year, month, and day.
‌If you specify "0" as the value for the day, the last day of the previous month will return. This is a very handy way, to determine the last day of a month.
‌Furthermore, a Unix time specification in milliseconds can be converted into a valid date.

Syntax

date(any)
date(number, number, number)

Return

‌date

Examples

Your result format may be different depending on your settings.
date(year, month, day) To return a date value.
date(2021, 8, 0)
Result: 07/31/2021 (US) (last day of the previous month)
date(myTimeValue) To convert a given time-related value to a date value. If the value is a number, it represents the Unix time in milliseconds.
date('Date + Time')
Result: Date from the field "Date + Time"
date(start('Appointment'))
Result: Date of the start of the Appointment field
date(1617873118285)
Result: 04/08/2021 (US)

‌See also

time, which returns the current time.
Export as PDF
Copy link