Question Re: Date time field in Technology Q&A

Date time field

Former Member — Tue, 05 Jul 2016 22:05:10 GMT

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 — Wed, 06 Jul 2016 03:31:47 GMT

Hi Paul,

Try:

Date({Date Time Field}) = CurrentDate

-Abhilash

Former Member — Wed, 06 Jul 2016 04:28:48 GMT

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