Show only records for the last year

AppSheet AppSheet Q&A
1

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.

2

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

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

Steve:

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

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

2 Likes