RE: DateSubtract Like DateAdd?

2003-10-16 Thread Philip Arnold
, 2003 7:45 PM To: CF-Talk Subject: RE: DateSubtract Like DateAdd? WOW Kinda of embarrasing.  Thanks! -- Original Message -- From: "Barney Boisvert" <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] Date:  Wed, 15 Oct 2003 16:39:26 -0700

RE: DateSubtract Like DateAdd?

2003-10-15 Thread Barney Boisvert
I remember asking the exact same question, so if embarassing, you're certainly not alone.  ; )   -Original Message-   From: Dwayne Cole [mailto:[EMAIL PROTECTED]   Sent: Wednesday, October 15, 2003 4:45 PM   To: CF-Talk   Subject: RE: DateSubtract Like DateAdd?   WOW Kinda of embarr

RE: DateSubtract Like DateAdd?

2003-10-15 Thread Dwayne Cole
WOW Kinda of embarrasing.  Thanks! -- Original Message -- From: "Barney Boisvert" <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] Date:  Wed, 15 Oct 2003 16:39:26 -0700 >just make the interval negative.  dateAdd("d", -14, now()) >  -Original Message

RE: DateSubtract Like DateAdd?

2003-10-15 Thread Barney Boisvert
just make the interval negative.  dateAdd("d", -14, now())   -Original Message-   From: Dwayne Cole [mailto:[EMAIL PROTECTED]   Sent: Wednesday, October 15, 2003 4:33 PM   To: CF-Talk   Subject: DateSubtract Like DateAdd?   How about a dateSubtract function? Does anyone know it there is a

Re: DateSubtract Like DateAdd?

2003-10-15 Thread Jeff Garza
You can supply negative numbers to DateAdd... DateAdd("d", "-1", Now()) Subtracts a day from Today. Jeff   - Original Message -   From: Dwayne Cole   To: CF-Talk   Sent: Wednesday, October 15, 2003 4:32 PM   Subject: DateSubtract Like DateAdd?   How about a dateSubtract function? Doe