Encoded query for exactly 60 days and 90 days

[Richard Thomas2]

Hi all,

I've trying to set up a scheduled job that runs daily and identifies records exactly 60 days old and 90 old to notify the user to update.

I initially used encoded query active=true^sys_updated_onRELATIVELT@dayofweek@ago@60 and the same for 90 but that sends the user a daily email - I only want to send it once. I also tried the below without success

sys_created_onRELATIVEGT@dayofweek@ago@59^sys_created_onRELATIVELT@dayofweek@ago@61

Does anyone have any experience of scripting something like this?

Appreciated as always!

Richard

[Ankur Bawiskar]

@Richard Thomas 

You can check script shared by Mahendra and share us the updates.

Regards
Ankur