Filter condition

[Rosy14]

How to get list of records where end date is not more than 14 days from current date?

[Aman Kumar S]

Hi @Rosy14 

You can use below filter condition:

You can ignore the state is new condition, I have applied filters for Planned start date.

[Naga Ravindra R]

Hi @Rosy14 

following will help:

encoded query is : 

end_dateRELATIVELT@dayofweek@ahead@14

Let me know if you need more help on any script

[Rosy14]

Why it is not coming for me?

[Rosy14]

Resoled

[AndersBGS]

Hi @Rosy14 ,

Just utilize the relative operator as shown below:

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

best regards

Anders