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

[Former Member]

Hi Paul,

May be the datetime field is in string format, If Abhilash formula is not working for your then try this:

Left({datetimefield},10) = Totext(currentdate,'yyyy-mm-dd')

Thanks,

Sastry