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 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.
Returns a date that is numDays working days after startDate. Working days exclude weekends and an optional list of holidays, formatted as a comma-separated string of ISO-formatted dates.
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.