> Here's an excerpt direct from ColdFusion Studio's help pages ;) Thanks. Well, that's what I get for relying on the popup help and the O'Reilly function reference...
> When datepart is Weekday ("w"), DateDiff returns the number > of weeks between > the two dates. If date1 falls on a Monday, DateDiff counts > the number of > Mondays until date2. It counts date2 but not date1. If > interval is Week > ("ww"), however, the DateDiff function returns the number of > calendar weeks > between the two dates. It counts the number of Sundays > between date1 and > date2. DateDiff counts date2 if it falls on a Sunday; but it > doesn't count > date1, even if it does fall on a Sunday. This seems counterintuitive, doesn't it? One would assume weeks between dates would be 7-day units, just like months between dates is handled. Also, another poster says that CFMX has changed the DateDiff calc for 'ww'... Chris ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com