setting notification email to fire 90 days before expiry date

[robertcook]

Hi All,

I am trying to create an event that will fire a notification to a company 90 days before the expiry of their license. I am new to SNOW and have hit a road block with the scheduled job any help would be appreciated.

[Nazhath Mariam]

Hi

lic.addQuery('u_date_of_expiry',gs.daysAgo(-5));  is not working for me

nor is lic.addQuery('u_date_of_expiry',"=",gs.daysAgo(-5));