Why not keep using DateAdd?
DateAdd('d',-14,now()) and DateAdd('d',14,now())
Tom
At 7/31/00 11:13 AM, you wrote:
>This is a multi-part message in MIME format.
>
>------=_NextPart_000_1637_01BFFAE0.554B4DC0
>Content-Type: text/plain;
> charset="iso-8859-1"
>Content-Transfer-Encoding: quoted-printable
>
>Is there a way to substract days from a date value similar to the =
>dateAdd function in CF. I looked through the manual and I am not seeing =
>anything. What I am trying to do is set up date values 2 weeks before =
>and 2weeks after todays date.
>
>Thanks!
>
>Kevin Schmidt
>Internet Services Manager
>Peterson, WIlliams & Bizer
>Office: 734.995.5000
>Mobile: 734.649.4843
>
>
>------=_NextPart_000_1637_01BFFAE0.554B4DC0
>Content-Type: text/html;
> charset="iso-8859-1"
>Content-Transfer-Encoding: quoted-printable
>
><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
>Is there a way to substract days from a = date value=20 similar to the
>dateAdd function in CF. I looked through the manual = and I=20 am not
>seeing anything. What I am trying to do is set up date = values 2=20
>weeks before and 2weeks after todays date.
>
>Thanks!
>Kevin Schmidt
>Internet Services=20 Manager
>Peterson, WIlliams & Bizer
>Office: = 734.995.5000
>Mobile:=20 734.649.4843
>
>------=_NextPart_000_1637_01BFFAE0.554B4DC0--
>
>------------------------------------------------------------------------------
>Archives: http://www.mail-archive.com/[email protected]/
>To Unsubscribe visit
>http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
>send a message to [EMAIL PROTECTED] with 'unsubscribe' in
>the body.
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.