topic Re: Today() - what am I doing wrong? in App Development

Today() - what am I doing wrong?

jlampard40 — Wed, 22 Dec 2021 16:36:32 GMT

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.

Re: Today() - what am I doing wrong?

sunny_talwar — Tue, 01 Oct 2019 11:49:39 GMT

Try this

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

Or this

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

Re: Today() - what am I doing wrong?

jlampard40 — Tue, 01 Oct 2019 12:49:17 GMT

Thanks Sunny! 🐵