Support for the Date and Time type

The type Date and Time is now fully supported in calculated fields. For example, easily calculate the number of work days since the last update with NETWORKDAYS(TO_DATE({updated_at}),TODAY()). Or you could use NOW()-{updated_at} and get the number of calendar days, with decimals showing fractions of a day.

New Date and Date and Time functions

Name	Description
NOW	Returns current date and time.
DATE_TIME	Forms a date and time.
NETWORKDAYS	Returns the numbers of work days between two dates, as a duration.
WORKDAY	Returns a date that is a number of work days after a date.

New type conversion functions

Name	Description
TO_DATE	Converts a date and time value to a date.
TO_SECONDS	Converts a duration to a number of seconds.
TO_MILLISECONDS	Converts a duration to a number of milliseconds.
TIMECODE_STR	Converts a number of frames and a frame rate into a timecode string.

New math function

Name	Description
MOD	Returns the remainder of a division.

Documentation

To learn more about these new functions, check out our documentation here.

Release Information

Version:

8.66

Release Date:

September 2024 ET