Date functions

Date functions

DATE(year [,month,day,hours,min,sec, ms])
Creates a Date object from the specified arguments.

DATEVALUE(year [,month,day,hours,min,sec, ms])
Creates a Date object from the specified arguments.

DATE(expression)
Creates a Date object by evaluating expression.

TODATE(expression[,input format])
Converts a date string or number to a Date object. If you do not specify the input format, the date string must be an ISO 8601 date string. Example TODATE("2001-01-01") returns a Date object representing January 1st, 2001 Example TODATE("20.12.2006", "DD.MM.YYYY") return a Date object representing Dec 20th 2006.

NOW()
Returns the current Date.

FORMATDATE(date : Date | string,format : string)
Returns a string representation of a date using the specified format and the current locale. The formatting function supports momentjs formats. If the date passed to the function is a string and not a date object, the format of the string is expected to be ISO 8601.