http://livedocs.adobe.com/ Macromedia LiveDocs - online documentation with user feedback. Copyright 2009, Macromedia, Inc. 2009-11-25T08:02:42 en-us http://livedocs.adobe.com/coldfusion/6.1/htmldocs/functi55.htm#41131 I have entered this as a bug (#61361). ASandstrom 0 0 2005-10-21T07:29:04 http://livedocs.adobe.com/coldfusion/6.1/htmldocs/functi55.htm#41122 There appears to be a bug in the DateAdd with weekdays. If you add five week days to a Friday date, you get a date on a Sunday! If you add six days to a Thursday, you get a Friday, as expected:<br /><br /><cfoutput><br /><br /> <cfset ThursdayDate = CreateDate(2005, 10, 20)><br /> <cfset FridayDate = CreateDate(2005, 10, 21)><br /><br /> <cfset ThursdayPlusSix = DateAdd( "w", 6, ThursdayDate )><br /> <cfset FridayPlusFive = DateAdd( "w", 5, FridayDate )><br /><br /> <P>Six weekdays after #LSDateFormat( ThursdayDate, "dddd" )# (#ThursdayDate#) is #LSDateFormat( ThursdayPlusSix, "dddd" )# (#ThursdayPlusSix#)<br /> <P>Five weekdays after #LSDateFormat( FridayDate, "dddd" )# (#FridayDate#) is #LSDateFormat( FridayPlusFive, "dddd" )# (#FridayPlusFive#)<br /><br /></cfoutput> Greg Thomas 0 0 2005-10-21T03:45:32 http://livedocs.adobe.com/coldfusion/6.1/htmldocs/functi55.htm#27008 DateAdd("d", 1, "12/30/2004") gives you a date of 12/31/2004<br />DateAdd("d", 1, "12/31/2004") gives you a date of 12/31/2004<br /><br />I'm guessing that's a bug. fgwenger 0 0 2005-01-26T08:16:47 http://livedocs.adobe.com/coldfusion/6.1/htmldocs/functi55.htm#12989 It might be worthwhile to specify that the <em>number</em> argument takes only an <em>integer</em> value, not just a numeric. EG: you cannot add 1.5 days using dateAdd(), only whole units. Adam Cameron 0 0 2004-04-15T16:49:36