Using Date formatting in set analysis

[SaturnV]

I am trying to create a set analysis where my date field "Datum" is equal current YearMonth.

Count({<=[Datum.autoCalendar.YearMonth]={"Date(Today(), 'YYYY-MMM')"}>} MyId)

 Where:

Date(Today(), 'YYYY-MMM')

Prints "2021-Juni"

and

=[Datum.autoCalendar.YearMonth]

Prints "2021-Juni", "2021-Mai", "2021-Apr.", ...

However the Set analysis is always 0

But this:

Count({<[Datum.autoCalendar.YearMonth]={'2021-Juni'}>} MyId)

Is working perfectly fine.

Maybe it is an issue with the quotation marks. I already tried "" and '' switching around but no change.

Any suggestions?

[sunny_talwar · Accepted solution]

Try this

Count({<=[Datum.autoCalendar.YearMonth] = {"$(=Date(Today(), 'YYYY-MMM'))"}>} MyId)

[SaturnV]

Thank you very much. This did the trick 🙂