Show only records for the last year

[Nathan_Aycock]

I am trying to create a slice which shows only the rows which have a value in the date column which is within the last 12 months. I am running into a dead end trying to build or find an expression for this.

Any assistance is greatly appreciated.

[Steve]

Depends on how you define “the last 12 months”, but you could try this:

([Date] > EOMONTH(TODAY(), -12))

[Nathan_Aycock]

Steve:

([Date] > EOMONTH(TODAY(), -12))

Thanks Steve! You are always on point man. Much appreciated!