RE: minus 30

2007-09-28 Thread Andrew Clark
You have to parse "20070927" into a date object, something like: -Original Message- From: Orlini, Robert [mailto:[EMAIL PROTECTED] Sent: Friday, September 28, 2007 8:51 AM To: CF-Talk Subject: RE: minus 30 1 month is fine. enddate is 20070927 (for now) and is a str

RE: minus 30

2007-09-28 Thread Orlini, Robert
1 month is fine. enddate is 20070927 (for now) and is a string: I get: 568511220 as the output -Original Message- From: Jerry Johnson [mailto:[EMAIL PROTECTED] Sent: Thursday, September 27, 2007 2:12 PM To: CF-Talk Subject: Re: minus 30 Do you want 30 days, or 1 month? They are not the

Re: minus 30

2007-09-27 Thread Ben Doom
11220 as the output > > How can I get 20070827. I don't weant to use the now()) function because the > enddate can be any day not just today. > > Thx. > > > -Original Message- > From: Tom Chiverton [mailto:[EMAIL PROTECTED] > Sent: Thursday, Septemb

Re: minus 30

2007-09-27 Thread Jerry Johnson
d date? Suppose the endate is > 9/1/2007...how can I subtract 30 days from that? That's where I got: > #DateAdd("d", -30, enddate)#. > > -Original Message- > From: Jerry Johnson [mailto:[EMAIL PROTECTED] > Sent: Thursday, September 27, 2007 11:31 AM > To: C

RE: minus 30

2007-09-27 Thread Orlini, Robert
om: Tom Chiverton [mailto:[EMAIL PROTECTED] Sent: Thursday, September 27, 2007 11:48 AM To: CF-Talk Subject: Re: minus 30 On Thursday 27 Sep 2007, [EMAIL PROTECTED] wrote: > Note this subtracts a month (so March 28 becomes Feb 28), which is not the same thing as subtracting 30 days. I'm not

RE: minus 30

2007-09-27 Thread Orlini, Robert
y, September 27, 2007 11:31 AM To: CF-Talk Subject: Re: minus 30 (you need to do the dateAdd, and then do the dateFormat, and then do the compare). (you can also look at dateCompare rather than the eq, if you want) On 9/27/07, Orlini, Robert <[EMAIL PROTECTED]> wrote: > Hi, > > Ho

RE: minus 30

2007-09-27 Thread Orlini, Robert
That did it! Thanks Jerry and thanks all others for thier input. I got a little from each... -Original Message- From: Jerry Johnson [mailto:[EMAIL PROTECTED] Sent: Thursday, September 27, 2007 11:31 AM To: CF-Talk Subject: Re: minus 30 (you need to do the dateAdd, and then do the

RE: minus 30

2007-09-27 Thread Bobby Hartsfield
http://acoderslife.com -Original Message- From: Tom Chiverton [mailto:[EMAIL PROTECTED] Sent: Thursday, September 27, 2007 11:48 AM To: CF-Talk Subject: Re: minus 30 On Thursday 27 Sep 2007, [EMAIL PROTECTED] wrote: > Note this subtracts a month (so March 28 becomes Feb 28), which is not

RE: minus 30

2007-09-27 Thread Bobby Hartsfield
Use dateadd with -1 for the month instead of -30 for the day. ..:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com -Original Message- From: Orlini, Robert [mailto:[EMAIL PROTECTED] Sent: Thursday, September 27, 2007 11:24 AM To: CF-Talk Subject: minus 30 Hi, Ho

RE: minus 30

2007-09-27 Thread Andrew Clark
> I'm not sure what it does if you try and subtract one month from March 30th though. In CF 7 is gives Feb 28 Andrew -Original Message- From: Tom Chiverton [mailto:[EMAIL PROTECTED] Sent: Thursday, September 27, 2007 11:48 AM To: CF-Talk Subject: Re: minus 30 On Thursda

Re: minus 30

2007-09-27 Thread Tom Chiverton
On Thursday 27 Sep 2007, [EMAIL PROTECTED] wrote: > Note this subtracts a month (so March 28 becomes Feb 28), which is not the same thing as subtracting 30 days. I'm not sure what it does if you try and subtract one month from March 30th though. -- Tom Chiverton Helping to dynamically orchest

Re: minus 30

2007-09-27 Thread Jerry Johnson
(you need to do the dateAdd, and then do the dateFormat, and then do the compare). (you can also look at dateCompare rather than the eq, if you want) On 9/27/07, Orlini, Robert <[EMAIL PROTECTED]> wrote: > Hi, > > How can I subtract one month (30 days) from a value? > > The coding I have is: >