April 19, 2007 03:19 PM

DATETIME Calculations, Part 4

Calculate first/last occurrences of a weekday in a month
Rating: (0)
SQL Server Magazine
InstantDoc ID #95271
Datetime calculations are challenging. They often involve tricky logic. In the past three columns, I've gone into depth about datetime calculations, covering various types, including calculating the date of the first and last days of a month based on a given event datetime value, and calculating the last and next occurrences of a weekday. This month, I present techniques for calculating the date of the first and last occurrences of a weekday in a month, based on a given event date—fo...

...This article is for paid Professional Members only.

Already a Professional Member? Please log in now:

NOT A PROFESSIONAL MEMBER? YOU CHOOSE:

Professional Membership

Monthly

Annual

VIP Membership

Monthly

Annual

Add a Comment

Nice tricks.

Thanks.

Marcos3/18/2009 10:53:39 AM


Thanks for pointing out the error with the table links; I'll get this fixed ASAP.

Anne7/16/2007 4:04:52 PM


The Table 1 and Table 2 links don't go anywhere.

Alexander7/16/2007 7:59:44 AM


You must log on before posting a comment.

Are you a new visitor? Register Here
GOOGLE LINKS
SPONSORED LINKS
FEATURED LINKS