FIlter to get records with due date after 3 days

[Shivani29]

Hi All,

I am adding filter on a table where i want to get the records with state is 2 and due date is 3 days from today. for example: today is 10th June , so I want the records with due date 13th june. I used below filter but it is giving me the records with all due dates which are after 3 days from now.

state=2^questionnaire_due_dateRELATIVEGT@dayofweek@ahead@3

result of this is:

The circled one should not come. 

Any help please !!

Regards,
Shivani

[Chandu Telu]

Hi ,

Try the below query

due_dateRELATIVELT@dayofweek@ahead@3

Thanks

Chandu Telu

[Shivani29]

Hi,

Thanks for your reply. Already tried this but it gives all the records which due date was before 3 days from now and i need after 3 days exact.

Rgds,
Shivani

[einvaldserigsta · Accepted solution]

Hi,

You need to add both before and after query:

Giving you this query:due_dateRELATIVEGT@dayofweek@ahead@3^due_dateRELATIVELT@dayofweek@ahead@4

Hope this helps!

Einvald

[Shivani29]

Hi Einvald,

Thanks for your quick help. It is working.

Rgds,
Shivani