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 )

TODAY()

Today's date

TODAY()