How to send reminder notification before 30 days based on End Date

[chanikya]

Hi,

in catalog items, i have one filed, documents submit "Last  End Date"  (variable in catalog item)

ex: Last End Date=20/08/2018  19:50:20  then notification trigger one month before means on 20/07/2018.

So how can we do it.

my Br script is not working...

if(gs.dateDiff(gs.nowDateTime(), current.variables.ex_date.getDisplayValue(),true)/3600>=720)
{
var gdt = new GlideDateTime(current.variables.ex_date.getDisplayValue());
gdt.addDaysLocalTime(-30);
gs.eventQueueScheduled ( "thirty" , current, gs. getUserID ( ) , gs. getUserName ( ) , gdt) ;

}

[Ct111]

Hi chanikya,

If you are writing this script for workflow then let it be ,  because in Workflow you can attach a Timer activity in which there is option of  setting field based on a date type.  And then after the timer you can

attach Notification , as a result notification will directly be trigger 30 days before that . See the screenshot

Mark my ANSWER as CORRECT if it served your purpose.

[chanikya]

but here End Date is Variable

So how can i  do it?

[Ankur Bawiskar]

Hi Chanikya,

So before 30days from the end date you need to trigger the email.

following query you can use:

my field u_sample_date you can replace with yours

u_sample_dateRELATIVEGE@dayofweek@ahead@30^u_sample_dateRELATIVELE@dayofweek@ahead@31

Mark Correct if this solves your issue and also hit Like and Helpful if you find my response worthy based on the impact.
Thanks
Ankur

[chanikya]

shall i have to write Schedule job for this?

end Date is Variable in RITM