1 Reply Latest reply on Sep 20, 2006 4:57 PM by dempster

    variable day and specific time

      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?