how to add filter condition exactly after 30 days from todays date

[Aishwarya20]

Hi,

I want to write filter condition of date after 30 days from now, please help me.

[priya0895]

How can this be used as a query? 
for example :   sys_created_onRELATIVEGT@dayofweek@ahead@30  this can be used in encoded query???

[priya0895]

Hi Saurav, 

I want to check my recent import is from 2 weeks before. 

[Saurav11]

hello,

If recent import is from date/time field you can use the below:-

sys_created_onRELATIVELT@dayofweek@ahead@14 replace sys_created_on with recent_import

Thanks.

[Abhijit4 · Accepted solution]

Hi,

You can achieve it like below, the digit in the image is not clear, I have added it is 29 and 31. The logic here is "Due Date after 29 from today and before 31 days from now" which will give us records where due date is 30(after 29 and before 31 is 30) days.

Let me know if you have any further queries.

Please mark this as Correct or Helpful if it helps.

[Aishwarya20]

Hi,

It is working fine. but 90 days encoded query not working in script.