While similar to the NOW() function: TODAY() returns the current date (not the current time, if formatted, time will return 12:00am).
This function updates when the formula is recalculated, when a base is loaded, or otherwise roughly every 15 minutes when a base is open. If the base is closed, it will update approximately every hour only when the base has time-dependent automation triggers or actions, or sync dependencies.
While similar to the TODAY() function, NOW() returns the current date AND time.
This function updates when the formula is recalculated, when a base is loaded, or otherwise roughly every 15 minutes when a base is open. If the base is closed, it will update approximately every hour only when the base has time-dependent automation triggers or actions, or sync dependencies.
Returns the second of a datetime as an integer between 0 and 59.
Returns the minute of a datetime as an integer between 0 and 59.
Returns the hour of a datetime as a number between 0 (12:00am) and 23 (11:00pm).
Returns the day of the month of a datetime in the form of a number between 1-31.
Returns the day of the week as an integer between 0 (Sunday) and 6 (Saturday).
Returns the month of a datetime as a number between 1 (January) and 12 (December).
Returns the week number in a year. You may optionally provide a second argument (either "Sunday" or "Monday") to start weeks on that day. If omitted, weeks start on Sunday by default. Example: WEEKNUM(TODAY(), "Monday")
Returns the four-digit year of a datetime.
Calculates the number of days between the current date and another date.
Calculates the number of days between the current date and another date.
Determines if [date1] is earlier than [date2]. Returns 1 if yes, 0 if no.
Determines if [date1] is later than [date2]. Returns 1 if yes, 0 if no.
Compares two dates up to a unit and determines whether they are identical. Returns 1 if yes, 0 if no.
Formats a datetime into a string (YYYY-MM-DD).
Formats a datetime into a time-only string (HH:mm:ss).
Returns the difference between datetimes in specified units. The difference between datetimes is determined by subtracting [date2] from [date1]. This means that if [date2] is later than [date1], the resulting value will be negative.
Default units are seconds. (See list of unit specifiers here.)
Note: The DATETIME_DIFF() formula will return whole integers for any unit specifier.
Counts the number of working days between startDate and endDate. Working days exclude weekends and an optional list of holidays, formatted as a comma-separated string of ISO-formatted dates.
Interprets a text string as a structured date, with optional input format and locale parameters. The output format will always be formatted 'M/D/YYYY h:mm a'.
Formats a datetime into a specified string. For an explanation of how to use this function with date fields, click here. For a list of supported format specifiers, please click here.
Adds specified "count" units to a datetime. (See list of shared unit specifiers here. For this function we recommend using the full unit specifier for your desired unit.)
Sets a specific locale for a datetime. Must be used in conjunction with DATETIME_FORMAT. A list of supported locale modifiers can be found here.
Sets a specific timezone for a datetime. Must be used in conjunction with DATETIME_FORMAT. A list of supported timezone identifiers can be found here.