Date Functions

DATE(D, F)

Prints date D in F format (y, M, d, H, m, s)

DATE( TODAY(), "HH:mm:ss yyyy-MM-dd" )

TO_DATE(A, F)

Parses string A to date using format F (y, M, d, H, m, s)

TO_DATE( documentDate, "yyyy-MM-dd" )

DAYS(D)

Convert number of days D to date

DAYS(3)

TODAY() + DAYS( 30 )

DAYS_BETWEEN(A, B)

Calculates number of days between two dates A and B

DAYS_BETWEEN( periodStart, periodEnd )

WORKDAYS_BETWEEN(A, B)

Calculates number of working days between two dates A and B

WORKDAYS_BETWEEN( firstDate, lastDate )

TODAY()

Today's date

TODAY()

MONTH(D)

Gets the month-of-year from a date value. Month values are in range 1 to 12

MONTH( date )

YEAR(D)

Gets the year from a date value.

YEAR( date )

MIDNIGHT(D)

Converts date value to a date with midnight time.

MIDNIGHT( date )

SAME_DAY(A, B)

Compares two date values ignoring the time to find out whether two dates are the same day.

SAME_DAY( fromDate, toDate )

SAME_WEEK(A, B)

Compares two date values to find out whether thy are in the same week.

SAME_WEEK( fromDate, toDate )

CALENDAR_DAYS(Y, M)

Generates an array of date values for year Y and month M. Month values are in range 1 to 12. Helpful function to generate calendar.

CALENDAR_DAYS( 2024, 1 )

---

Was this article helpful?