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?
@KrupeshJ2347
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.
@KrupeshJ2347
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.
@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.
@KrupeshJ2347
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”,“”,“”)
@MS91781 Thanks for the idea