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.