inserted the date using DateFormat(Now()). Unfortunately it gives me
an error that dateAdded is unidentified. True, it's a column and I
want it to search the column for anything less than 7 days old. Can
anyone help me word this WHERE?
<CFQUERY NAME="whatsnew" DATASOURCE="puhweb">
select * FROM whats_new
WHERE '#DateDiff("d",dateAdded,the_date)#' < 7
order by dateAdded DESC
</CFQUERY>
thanks.
--
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]