http://www.sqlservercentral.com/Scripts tagged T-SQL, Datetime Manipulation posted on SQLServerCentral.comen-us360sjones@sqlservercentral.com (Steve Jones)You Can Find Some Date Functions and extracting the different Date Formats using the Convert and Casthttp://www.sqlservercentral.com/scripts/Datetime+Manipulation/61393/2008/02/01http://www.sqlservercentral.com/scripts/Datetime+Manipulation/61393/Calculates the nth due date for any given date, while accounting for weekends.http://www.sqlservercentral.com/scripts/User-defined+function/61300/2007/12/03http://www.sqlservercentral.com/scripts/User-defined+function/61300/