Send notification to the Requested for and the abc group 30 days before the Duration date is reached

Samiksha2
Mega Sage

Hi All,

I have created a date field in the catalog form. 

lets say I put duration as 12/31/2024.

30 days before the Duration date is reached, we have to notify requested for and "abc" group that your ticket is expiring.

 

Please help in this.

 

Thanks,

Samiksha

1 ACCEPTED SOLUTION

Community Alums
Not applicable

Hello @Samiksha2 ,

 

In When to send of notification Add Filter Condition :

Duration(ur date field) relative after 30 Days from now.

AND

Duration(ur date field) relative before 31 Days from now.

query:durationRELATIVEGT@dayofweek@ahead@30^due_dateRELATIVELT@dayofweek@ahead@31

 

@Samiksha2 , Please mark my answer as "Accept as Solution" and "Helpfuls." If it works for you.

 

Thank You!

 

 

View solution in original post

9 REPLIES 9

Community Alums
Not applicable

Hello @Samiksha2 ,

 

In When to send of notification Add Filter Condition :

Duration(ur date field) relative after 30 Days from now.

AND

Duration(ur date field) relative before 31 Days from now.

query:durationRELATIVEGT@dayofweek@ahead@30^due_dateRELATIVELT@dayofweek@ahead@31

 

@Samiksha2 , Please mark my answer as "Accept as Solution" and "Helpfuls." If it works for you.

 

Thank You!

 

 

Hi @Community Alums ,

 

Thank you for your reply.

I have added the conditions on insert and update

Samiksha2_0-1692612245941.png

 

Is this correct?

 

Thanks,

Samiksha

Community Alums
Not applicable

@Samiksha2 , Yes this is correct.

Thank you @Community Alums . I will test it and mark your answer as correct.😊