Today() - what am I doing wrong?

[jlampard40]

I have the following set analysis formula:

=count({<[WBR_Stat_Date]={'Today()'}>} [WBR_Event_Key])

I would like to just count the [WBR_Event_Key] relating to those records which only have today's date on them.  The field for this is [WBR_Stat_Date] - I need to identify the data relevant to today() only.  Help!

many thanks. 

[sunny_talwar · Accepted solution]

Try this

=Count({<[WBR_Stat_Date] = {"$(=Today())"}>} [WBR_Event_Key])

Or this

=Count({<[WBR_Stat_Date] = {"$(=Date(Today()))"}>} [WBR_Event_Key])

[jlampard40]

Thanks Sunny! 🐵