
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
date from previous month
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
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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)

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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)

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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 )

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
