Hey team!
Would anyone know an efficient way to create a dynamic filter that would filter out data prior to January 1st, 3 years ago? Filtering out data based on 3 years ago is pretty straight forward but what I'm unclear on is the "January 1st" part. Any ideas?
Solved! Go to Solution.
Should be able to use a filter tool with the following:
[Date] < DateTimeTrim(DateTimeAdd(DateTimeNow(),-3,'year'),'year')
Before:
After: