cheers
Chris
-----Original Message-----
From: Robert Orlini [mailto:[EMAIL PROTECTED]
Sent: vendredi 12 décembre 2003 15:44
To: CF-Talk
Subject: RE: seven days earlier
That worked well thanks.
One more thing: How do I convert the string: {ts '2003-12-05 09:37:09'} into
12-05-03 or any date string w/o the "{ts '" ?
Robert O.
-----Original Message-----
From: BOUDOT Christian [mailto:[EMAIL PROTECTED]
Sent: Friday, December 12, 2003 8:54 AM
To: CF-Talk
Subject: RE: seven days earlier
use the the DataAdd function
DateAdd("d", -7, Now())
-----Original Message-----
From: Robert Orlini [mailto:[EMAIL PROTECTED]
Sent: vendredi 12 décembre 2003 14:44
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]
