Question
Lantiqx Systems India Private Limited
IN
Last activity: 8 Feb 2022 3:56 EST
Selected date minus 7 days
Hello,
I need to send goal and deadline alerts 7 days before the selected date, and the deadline at 3 days before the selected date. Do you have any suggestions for how to accomplish this?
Accepted Solution
Updated: 8 Feb 2022 2:28 EST
Cognizant Technologies Services
IN
As Harshad mentioned below, please use @addToDate() function to set goal, deadline and pastdeadline properties, on change of selected date( if date selection is from UI). Then use those three properties in SLA rule.
Updated: 8 Feb 2022 0:18 EST
Aaseya IT services Pvt Ltd
SA
You can use the addToDate function in the activity.
For example @addToDate(.SelectedDateTime,-7,0,0,0) , will return you the date removing 7 days from the SelectedDateTime.
Please refer the attachment for more details.
Accepted Solution
Updated: 8 Feb 2022 2:28 EST
Cognizant Technologies Services
IN
As Harshad mentioned below, please use @addToDate() function to set goal, deadline and pastdeadline properties, on change of selected date( if date selection is from UI). Then use those three properties in SLA rule.
Lantiqx Systems India Private Limited
IN
@MS91781 addDate function is working but when I try to save the date value its getting in 20320109 in this format, but I want that in 09/01/2032. How can I achieve that, any ideas. Thanks in advance.
Updated: 8 Feb 2022 2:27 EST
Cognizant Technologies Services
IN
Please use this function to arrive at required format and then map it in SLA rule
FormatDateTime(@addToDate(.pxCreateDateTime,-7,0,0,0),"dd/MM/yyyy","","")