Date time field

[Former Member]

I have a datetime field, and need to report on the entire day. I'm having trouble using   currentdate

with this sort of data, it can only work if I hard code a date like 2016-07-06. I would like to use currentdate, is this possible?

2016-07-06 08:20:00.000

[abhilash_kumar · Accepted solution]

Hi Paul,

Try:

Date({Date Time Field}) = CurrentDate

-Abhilash