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

Question

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?

Luke_C · Accepted Answer

Hi @Rob_4142

Try this:

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