Filtering out data prior to Jan 1st, 3 years ago

[Rob_4142]

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?

[DataNath]

Should be able to use a filter tool with the following:

[Date] < DateTimeTrim(DateTimeAdd(DateTimeNow(),-3,'year'),'year')

Before:

After:

[Luke_C · Accepted solution]

Hi @Rob_4142 

Try this:

[Dates] != tostring(Datetimeyear(datetimetoday())-3) + '-01-01'