TODAY() not workig with datetime

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 Solved
0 4 256
1 ACCEPTED SOLUTION

Maybe:

	(TODAY() = DATE([Data]))

View solution in original post

4 REPLIES 4

Maybe:

	(TODAY() = DATE([Data]))

Maybe [Date]>=TODAY()-1

Bahbus
New Member

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

Top Labels in this Space