Set Expressions with Dates

[mhorsfall]

I am struggling with some date ranges in my dashboard. Trying to get values for a 12-month period starting with the previous month. When I use the expression:

Sum({<[calendar.full_date] = {">9/30/2022 <10/1/2023"}>} (([Amount2]/100))) I get the values I am looking for, but when I use:

Sum({<[calendar.full_date] = {">Date(MonthEnd(AddMonths(Today(), -13))) <Date(MonthStart(Today()))"}>(([Amount2]/100))) the output is just 0.

Would appreciate any insight. I have already checked and changed the data type in my data load for calendar.full_date field by using:

Date(calendar.full_date) AS calendar.full_date

[BrunPierre · Accepted solution]

Hi, try

{">$(=Date(MonthEnd(AddMonths(Today(), -13)))) <$(=Date(MonthStart(Today())))"}

[mhorsfall]

That did it! Thank you!