Last two months only

[StuartOxley]

Hi 

I'm trying to show the results of the last two months not including the current month.

I can get the last 4,5 & 6 months by using the following:

sum({<

Month,Date={"<=$(=Date(AddMonths(Now(),-3)-1, 'DD/MM/YYYY'))>=$(=Date(AddMonths(Now(), -4-1), 'DD/MM/YYYY'))"},

I cannot get the last 2 & 3 months and get 1, 2 & 3 months when I use: 

Sum( {<

Month,Date={"<=$(=Date(AddMonths(Now(),-1), 'DD/MM/YYYY'))>=$(=Date(AddMonths(Now(), -3), 'DD/MM/YYYY'))"},

Can someone tell me how I can do this please?

KR

Stuart

[MatheusC · Accepted solution]

Hi, @StuartOxley 

Try something like
Sum({<Month,Date={">=$(=MonthStart(AddMonths(today(),-2)))<=$(=MonthEnd(AddMonths(today(),-1)))"}>} sales)

[StuartOxley]

Hi @MatheusC that has worked perfectly, awesome! 

Thank you

[StuartOxley]

Hi @MatheusC 

Can you tell me how I can enter this from todays date please? 

[MatheusC]

I only inserted today(1) next to the date conversion

$(=Date(Today(1),'DD/MM/YYYY'))