Which one, the time-stamp?
As far as getting it working, I did mention that I used:
WHERE dateAdded < #dateAdd("d",-7,Now())#
which didn't have the DateFormat or the single-quotes.
Since there was several options mentioned I was trying to learn more
about the problems that I encountered with each. so are you saying
that I should try out an oracle version of
cfsqltype="cf_sql_timestamp"?
--
Daniel Kessler
Department of Public and Community Health
University of Maryland
Suite 2387 Valley Drive
College Park, MD 20742-2611
301-405-2545 Phone
www.phi.umd.edu
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]