Last Month Expression

[hopkinsc]

Hi all,

I have the following expression which returns data for the current month

sum({<[Issue Date]={'>=$(=monthstart(today()))<=$(=monthend(today()))'}>}Sales)

I also need 2 more expressions, 1 to return data for last month and 1 to return data for next month.

Can anyone help please?

[Gysbert_Wassenaar · Accepted solution]

previous month: sum({<[Issue Date]={'>=$(=addmonths(monthstart(today()),-1))<$(=monthstart(today()))'}>}Sales)

next month: sum({<[Issue Date]={'>$(=monthend(today()))<=$(=addmonths(monthend(today()),1))'}>}Sales)