Set Expressions with Dates

mhorsfall — Wed, 11 Oct 2023 17:17:01 GMT

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

Re: Set Expressions with Dates

BrunPierre — Wed, 11 Oct 2023 18:09:27 GMT

Hi, try

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

Re: Set Expressions with Dates

mhorsfall — Wed, 11 Oct 2023 18:21:30 GMT

That did it! Thank you!

topic Set Expressions with Dates in App Development

Set Expressions with Dates

Re: Set Expressions with Dates

Re: Set Expressions with Dates