Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
use expression
if (monthstart(mydates) > monthstart(addmonths(today(),-3)), mydates)
use expression
if (monthstart(mydates) > monthstart(addmonths(today(),-3)), mydates)