Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
shane_spencer
Specialist
Specialist

List Box - show only most recent 3 months

I've got a list box that has the Month Year going back to May 2013 and will continue to include more recent months as time goes on.

i.e.

I want to use an expression to show only the most recent 3 months. This can either be based on today's date or simply the most recent 3 months as this will give the same result.

1 Solution

Accepted Solutions
Anonymous
Not applicable

use expression

if (monthstart(mydates) > monthstart(addmonths(today(),-3)), mydates)

View solution in original post

1 Reply
Anonymous
Not applicable

use expression

if (monthstart(mydates) > monthstart(addmonths(today(),-3)), mydates)