Rolling 12 months dates

[morganlunsford]

Hi,

How can I create a formula to remove any records that are not within 12 months of the current date?

Thanks!

[DataNath]

Hey @morganlunsford, if you stick the following expression in a Filter tool, you'll only get records from the last year coming out of the True anchor. Just replace [Date] with the name of your actual date field.

[Date] >= DateTimeAdd(ToDate(DateTimeToday()), -1, 'year')