variable day and specific time

[280844]

I am attempting to create a query that returns db records based upon date and time the date changes (IsToday) but the time is a constant (4:30 pm).

<CFPARAM name="IsToday" DEFAULT="#CreateODBCDate(Now())#">

Is there a way to append a time constant to Now() so that only records with a datetime that is less than Now() 16:30:00 would be identified?

[dempster · Accepted solution]

CreateDateTime(Year(Now()), Month(Now()), Day(Now()), 16, 30, 0)