Date & Time Functions

10 functions for date and time manipulation.

FunctionDescriptionInputs
NowCurrent date & time—
AddAdd time to a datedate, amount, unit
SubtractSubtract time from a datedate, amount, unit
DifferenceTime between two datesdate 1, date 2, unit
Date to TextFormat date as stringdate, format, timezone
Text to DateParse text into datetext, format
EpochDate to UNIX timestamp (seconds)date
ISODate to ISO 8601 stringdate
UNIXDate to UNIX formatdate
ConvertConvert between formatsdate, format

Example: Schedule Reminder

Schedule Reminder

Get current time, add 24 hours, format for display

Date & Time

Now

output

Date & Time

Add

date
output
amount
24
unit
hours
output

Date & Time

Date to Text

date
output
format
YYYY-MM-DD HH:mm
output

Units

For Add, Subtract, and Difference: milliseconds, seconds, minutes, hours, days, weeks, months, years.

Format Tokens

Common format tokens for Date to Text / Text to Date:

  • YYYY — year (2026)
  • MM — month (01-12)
  • DD — day (01-31)
  • HH — hour (00-23)
  • mm — minute (00-59)
  • ss — second (00-59)