You would use dateAdd() and add 7 days.

--
Timothy Heald
Web Portfolio Manager
Overseas Security Advisory Council
U.S. Department of State
571.345.2319

The opinions expressed here do not necessarily reflect those of the U.S.
Department of State or any affiliated organization(s).  Nor have these
opinions been approved or sanctioned by these organizations. This e-mail is
unclassified based on the definitions in E.O. 12958.

-----Original Message-----
From: Robert Orlini [mailto:[EMAIL PROTECTED]
Sent: Friday, December 12, 2003 8:50 AM
To: CF-Talk
Subject: seven days earlier

I have a CF application that needs to check a date field in an Access column
and send an email 7 days earlier than the date in that column.
For example if the date in the column is 12/31/03, I would need to do a
comparison. When the current date is 12/24/03 then send out an email.

How would I code this using dateformat(now) for the current date? I guess I
would need to use the CF scheduler for this or can I use this in a CF script
alone?

Thanks as always.

Robert O.
HWW
  _____
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

Reply via email to