Filter condition issue

[dmahendran]

Hello Guys,

I'm working on a report where I need to filter records based on a variable called "Stop Date" within a Multi-Row Variable Set (MRVS). The requirement is to display records exactly 21 days before the Stop Date. For example, if the Stop Date is August 31, the record should appear in the report on August 10. I tried using relative date conditions like before, after, and on, but I haven’t been able to achieve this specific condition. Any help or suggestions would be greatly appreciated.

[Mark Manders]

Have you tried "between 22 days before ... AND 20 days before ..."?

[dmahendran]

I’ve already tried using relative conditions like before and after, but they didn’t work as expected. My goal is to retrieve records where the Stop Date falls exactly 21 days from the current date, so they can be displayed in the report. However, I’m unable to get the correct results using filter options.

[dmahendran]

@Mark Manders    could mind share any snips of this condition?

[Ankur Bawiskar]

@dmahendran 

to get exact 21 days try the approach shared by @Mark Manders 

If that doesn't work then try to use a script based approach

If my response helped please mark it correct and close the thread so that it benefits future readers.