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 same thing (more than half the time) what does endate look like? a date object, or is it a YYYYMMDD string? On 9/27/07, Orlini, Robert <[EMAIL PROTECTED]> wrote: > One more thing Jerry > > How can I get one month prior to the end 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: CF-Talk > Subject: Re: minus 30 > > > <CFIF #get.enddate# eq #dateformat(dateAdd("m",-1,now()),"YYYYMMDD")#> > > (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: > > > > <CFIF #get.enddate# eq #dateformat(now(),"YYYYMMDD")#> > > Yes > > <cfelse> > > NO > > </CFIF> > > > > and they equal Yes all the time. > > > > Both these values check out OK and appear as: 20070927 > > But I need the #dateformat(now(),"YYYYMMDD")#> to go back one month > > I tried <CFSET expire = #dateformat(now(),"YYYYMMDD")#> > > and then > > #DateAdd("d", -30, expire)# but it displays as {ts '56852-03-30 00:00:00'} > > Thanks in advance. > > Robert O. > > HWW > > > > > > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Get involved in the latest ColdFusion discussions, product development sharing, and articles on the Adobe Labs wiki. http://labs/adobe.com/wiki/index.php/ColdFusion_8 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:289717 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
