Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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.
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'))"}