Date functions
Last updated
Last updated
Example of the left side value (L) is a date and the right side value (R) is a number, the expression returns a new date representing L with R number of days added.
Function
Description
Example Expression
Example Result
Date(input)
Explicitly converts the input to a date value. The input must be a string matching the format "YYYY-MM-DD HH:MM:SS"
Date("2016-03-10 14:00:00")
2016-03-10 14:00:00 (date)
Now()
Returns the current date and time
Now()
(current date and time as a date variable)
Format(x, pattern)
Formats x as a string, using the given pattern. See Formats
Format(d, "yyMMdd")
"160310"
Expression
Result
now() + 1
A date variable representing tomorrow.
now() - 1
A date variable representing yesterday.