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.
DATE(date,format)
//returns the date in the specified format
DATE(year,month,date)
//returns the date in the browser locale formatdate - 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.
Date.
Last updated
Was this helpful?
Was this helpful?
DATE("05/29/2024")
//returns 29/5/2024
DATE(2024,05,24)
//returns 24/5/2024