Robert O.
-----Original Message-----
From: Graham Pearson [mailto:[EMAIL PROTECTED]
Sent: Friday, December 12, 2003 9:52 AM
To: CF-Talk
Subject: RE: seven days earlier
DateFormat(DateString, "mm-dd-yy")
On Fri, 12 Dec 2003 09:43:48 -0500, Robert Orlini wrote
> 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]
