Calculated Fields Update (What's New since August 2024)
Calculated fields now include date-and-time type, duration between dates, timecode, modulus function, and more.
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