I want RITMs created exactly 14 days before , ( I want to run this report daily) how can I keep a filter on the RITM table? Can someone help me out with the filter condition?

[Madhurya]

I want RITMs created exactly 14 days before , ( I want to run this report daily) how can I keep a filter on the RITM table? Can someone help me out with the filter condition?

Eg: today date is April 14

I want records created exactly on April 1

Similarly for tomorrow

I want records created exactly on April 2

How can I keep a filter?

[Weird · Accepted solution]

You can try using a relative filter.

Created relative after 15 days ago

AND

Created relative before 13 days ago

You can fiddle with those, but that should give you RITMs created 14 days ago.

[OlaN]

Hi,

Something like this?