MTD for previous month

[#1]

HI all,

I m confused and not getting the logic..... for calculating "Month To date" for previous Month.

Please help by providing code for same . 🙂

[maneshkhottcpl]

Hi,

Please try the function.

=

addmonths(DateField,-1) . Ler me know is it useful or not?

Manesh Khot

[tresesco]

I guess you want to calculate some amount for last MTD, if it is so, you can use something like this:

sum({Date={">=$(=MonthStart(today(),-1)) <=$(=Addmonths(today(),-1))"}>} Amount)

Regards, tresesco