date
To convert to or return a date value
This function extracts the date from a timestamp. It also returns a date based on the 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 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.
β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.
βResult: Date from the field Date + Time
βResult: Date of the start of the Appointment field
βResult: 04/08/2021 (US)
βSee also
βtime
, which returns the current time.
Last updated