HI
i need to add a slice with only today
but with [Data] = TODAY() it’s true only with time 12:00
How to solve? thanks
Solved! Go to Solution.
Maybe:
(TODAY() = DATE([Data]))
Maybe [Date]>=TODAY()-1
When you compare a Date to a DateTime the Date is assumed to have time of 00:00 aka 12am. So, if [Data] is a DateTime then you need to strip the time part off to compare just the dates as @Heru put.
Thank you so much
User | Count |
---|---|
36 | |
31 | |
30 | |
20 | |
17 |