Today's Date

[jkupov]

I have a daily report in which I need to pull a quick report of today's appointments. I have been manually changing the date in the select expert to the current date but I want it to automatically use today's date.

I am using CR XI, and have entered the following into the formula editor in the select expert:

{SERVICE_APPOINTMENT.APT_DATE_TIME} = DateTime (CurrentDate)

This is not producing any results. I think the reason is because I have a DateTime field but am not specifying a time. So I need to change it to somehow select all appointments from today's date between 12:00:00AM and 11:59:59PM.

How do I do this?

 

[jdemmi]

what happens if you just use this

{SERVICE_APPOINTMENT.APT_DATE_TIME} = CurrentDate

-- Jason
"It's Just Ones and Zeros

 

[jkupov]

Oh... that was easy. Thanks!