Create formulas based on date and time, or transform dates from a different format
Within all formulas that use date and/or time, you can set how you want to structure the format.
The operators need to be used as followed: and are caps-sensitive:
Dates
Year = yyyy
Month = MM
Day = dd
Time
Hour = HH
Minute = mm
Seconds = ss
DATEFORMAT
This function converts a date from a specific format to a new, specified format.
Example
DateFormat('2015/09/29','yyyy/MM/dd','yyyy/dd/MM') = 2015/29/09
NOW
Returns the current date and time in defined format.
Example
NOW('HH:ss ddMMyyyy') = 13:55 21012019
TODAY
Returns a date in defined format. The second part of the formula adds or subtracts days from the current day. The example below is made on 21-01-2020.
Example
TODAY('ddMMyyyy',-4) = 17-01-2020
SUBTRACTTODAY
This function will count the days from today. The date format must be 'mm-dd-yyyy'. The example below is made on 01-21-2020.
SUBTRACTTODAY('01-20-2020') = -1