date from previous month

[gz]

Hi, I have expresion

Sum({<data_przyjecia={">=$(=date(floor(monthstart(addmonths(Today(),-1))), 'YYYY-MM-DD'))"<$(=date(MonthEnd(today()),'YYYY-MM-DD'))"}saldo_przyjecia_pln)

I need change this part $(=date(MonthEnd(today()),'YYYY-MM-DD') I need 2023-04-24, I need this same day but from previous month. Tomorrow it will be 2023-04-25, next day 2023-04-26 etc

[Aditya_Chitale · Accepted solution]

instead of monthend, use:

Sum({<data_przyjecia={">=$(=date(floor(monthstart(addmonths(Today(),-1))), 'YYYY-MM-DD'))"<$(=date(Addmonths(today(),-1),'YYYY-MM-DD'))"}saldo_przyjecia_pln)

Regards,

Aditya

[gz]

doesn't work

now it's working 

Sum({<data_przyjecia={">=$(=date(floor(monthstart(addmonths(Today(),-1))), 'YYYY-MM-DD'))<=$(=date(Addmonths(today(),-1),'YYYY-MM-DD'))"}>}saldo_przyjecia_pln)

[Chanty4u]

Try this

Sum({<data_przyjecia={">=$(=date(floor(monthstart(addmonths(Today(),-1))), 'YYYY-MM-DD'))<=$(=date(monthend(addmonths(Today(),-1)), 'YYYY-MM-DD'))"}>} saldo_przyjecia_pln)

[md_talib]

make variables.

vCalMinDate = Date(Addmonths(Monthstart(today(),-1),'DD/MM/YYYY')
vCalMaxDate = Date(Addmonths(today(),-1),'DD/MM/YYYY')

Sum({< data_przyjecia={">=$(vCalMinDate) <=$(vCalMaxDate)"}>} saldo_przyjecia_pln )

[Aditya_Chitale]

I copied the same expression from your post. Just changed Monthend(today()) to Addmonths(today(),-1).

If it helped, please don't forget to mark it as a solution.

Regards,

Aditya