Date functions

NAMEDESCRIPTION

DATEADD

Adds a specified number of days to the input date

DATEDIFF

Returns the number of days between two input dates

DAY

Extracts the day of the month from an input date

DATE.SET

Returns a date after changing the format

MONTH

Extracts the month from an input date

NOW

Returns the current date and timestamp

TODAY

Returns the current date

YEAR

Extracts the year from an input date

This section is being updated. Some formulas and functions may not be currently available in the visuals or the docs. We appreciate your understanding and patience as we work to provide comprehensive information about these formulas and functions.

Last updated