previous month to same day

[hopkinsc]

Hi all,

i am trying to get an expression working that will show me the previous month but to same day.

i.e.

today is 8th July, so i would want previous month to be from 1st-8th June.

can anyone help please?

[tresB]

May be like:

InMonthToDate (date, Today(), -1)

[Gysbert_Wassenaar · Accepted solution]

Maybe something like this:

sum({<MyDateField={'>=$(=num(monthstart(today(),-1)))<=$(=num(addmonths(today(),-1)))'}>} amount)