This month selection not working

[MCmiranda]

Hi all,

I want a button that filters on 'this month'. My column [Check Date] has date format dd/mm/yyyy

=Month(Today()) should work right?

It doesn't, at all, while I do have items in this month.

Anyone know what to do?

[GaryGiles · Accepted solution]

=Concat({1<[Check Date]={">=$(=MonthStart(Today()))<=$(=MonthEnd(Today()))"}>} [Check Date],';')

[MCmiranda]

Woww  😍  Thaknk you