Date Operators

Only DATE type values are allowed in these pieces

Click on Image to see full size image

Add months

Context: Workflow, Dashboard Widget, Computed field, Report

Adds the number of months input to the DATE put in the to box and returns a DATE type value. In the example shown, 3 months are added to today's date and a future date is returned. Say, the date is July 3rd, 2022. This piece, if executed today, will return October 3rd, 2022.

Add years

Context: Workflow, Dashboard Widget, Computed field, Report

Adds the number of years input to the DATE put in the to box and returns a DATE type value. In the example shown, 3 years are added to today's date and a future date is returned. Say, the date is July 3rd, 2022. This piece, if executed today, will return July 3rd, 2025.

Subtract months

Context: Workflow, Dashboard Widget, Computed field, Report

Subtracts the number of months input to the DATE put in the to box and returns a DATE type value. In the example shown, 3 months are subtracted from today's date and a past date is returned. Say, the date is July 3rd, 2022. This piece, if executed today, will return April 3rd, 2022.


Subtract years

Context: Workflow, Dashboard Widget, Computed field, Report

Subtracts the number of years input to the DATE put in the to box and returns a DATE type value. In the example shown, 3 years are subtracted from today's date and a past date is returned. Say, the date is July 3rd, 2022. This piece, if executed today, will return July 3rd, 2019.


Get date / Get day / Get month

Get Readable Month / Get Year

Context: Workflow, Dashboard Widget, Computed field, Report

Get date - Returns the date portion from the DATE dropped into the piece. Say, if TODAY was July 3rd, 2022. It will return 3.

Get day - Returns the day from the DATE dropped into the piece. Say, if TODAY was July 3rd, 2022 and it is a Sunday. It will return Sunday.

Get month - Returns the month in NUMBER format from the DATE dropped into the piece. Say, if TODAY was July 3rd, 2022. It will return 7.

Get Readable Month - Returns the month in TEXT format from the DATE dropped into the piece. Say, if TODAY was July 3rd, 2022. It will return July.

Get Year - Returns the year in NUMBER format from the DATE dropped into the piece. Say, if TODAY was July 3rd, 2022. It will return 2022.

Get time difference

Context: Workflow, Dashboard Widget, Computed field, Report

Returns the difference between 2 dates in the various number of time units.