topic Re: Counting number of dates ina field in App Development

Counting number of dates ina field

Markbhai — Fri, 26 Apr 2024 09:00:44 GMT

I have a field [Evidence Review] which contains dates (in this format: 4/25/2025 12:00:00 AM)

I want to be able to count the number of dates where the review is due in the future.

I am using the following, but getting zero.

=Count({<[Evidence Review]={">$(=Today())"}>} [Evidence Review])

Thanks

Mark

Re: Counting number of dates ina field

Anil_Babu_Samineni — Fri, 26 Apr 2024 09:03:36 GMT

Perhaps try this way?

=Count(If([Evidence Review]>TimeStamp(Today()), [Evidence Review]))

If that works, then see if you can do in set analysis. The reason behind the files in your database contains full timestamp and you are comparing with Just date because Today() will give only date format.

Re: Counting number of dates ina field

BrunPierre — Fri, 26 Apr 2024 10:01:00 GMT

Try

[Evidence Review]={">$(=Timestamp(Today(),'MM/DD/YYYY hh:mm:ss TT')"}>}

Alternatively, Convert as a date field in script

Date(Floor(Timestamp#([Evidence Review],'MM/DD/YYYY hh:mm:ss TT')),'MM/DD/YYYY') as [Evidence Review]

And then use this set modifier.

[Evidence Review]={">$(=Date(Today(),'MM/DD/YYYY'))"}