tag:blogger.com,1999:blog-4583365003930185416.post3657750729469122776..comments2024-01-29T01:48:06.546-06:00Comments on World of Whatever: Datediff, not doing what you think it doesBill Fellowshttp://www.blogger.com/profile/09363163555016521189noreply@blogger.comBlogger2125tag:blogger.com,1999:blog-4583365003930185416.post-33188548950870547132010-07-08T16:10:35.136-05:002010-07-08T16:10:35.136-05:00However, it does behave somewhat unexpectedly if y...However, it does behave somewhat unexpectedly if you do a SET DATEFIRST to change the weekday. We've done that to make weekends fall together for scheduling purposes rather than have Saturday as the tail of one week and Sunday as the start of the next. DateDiff treats that as a different week even though we've specified that they should be the same week. We found a workaround, but it sure seems to act like a bug in those cases.<br /><br />Still, I appreciate the reminder. Those are the sort of things that can be really frustrating until you figure out what's going on behind the scenes.Peter Schotthttps://www.blogger.com/profile/08234754312915202260noreply@blogger.comtag:blogger.com,1999:blog-4583365003930185416.post-61467250258393323832010-07-08T16:03:15.481-05:002010-07-08T16:03:15.481-05:00You could write an entire blog about questions I a...You could write an entire blog about questions I ask you, couldn't you? Thanks for this info, mu brain was in knots trying to figure it outTrevor Besthttps://www.blogger.com/profile/01031987227278315089noreply@blogger.com