DATE
The DATE function takes date as input, in the form of a string or as a tuple and returns it in the specified format. If the format is not specified it returns the date in the user's browser locale format.
Syntax
DATE(date,format)
//returns the date in the specified format
DATE(year,month,date)
//returns the date in the browser locale format
Arguments
date - The input date in the form of a string. It can also be a node reference or a measure that contains the date. Required.
format - The desired format in which the input date should be displayed. Optional.
(or)
year - number.
month - number.
date - number.
Return Value
Date.
Example
DATE("05/29/2024")
//returns 29/5/2024
DATE(2024,05,24)
//returns 24/5/2024
Last updated