Convert Dates to Numbers in the Field Builder
To calculate a time duration, such as the duration of a backup job, dates need to be converted to a numeric data type.
Append a suffix to a field to convert the date to a number.
With this suffix applied, the result is the number of milliseconds that have elapsed since the epoch time (midnight of January 1, 1970).
Example of a Duration Calculation:
${D.time - C.time}Where D is the Job Finish Time field and C is the Job Start Time field. Both C and D are date fields.