How to Find the Start and End Dates for the Current Week (and more)

Learn to calculate Start / First of Week, End of Week, Start of Next Week, Year, Quarter, and Month of the week, Week Numbers and more in T-SQL (Jeff Moden)

Update only Year, Month or Day in a SQL Server Date

In this tip we look at how to change specific parts of a date such as the Year, Month or Day for data stored in a SQL Server table.

Binary Date Conversions

Calculate Age (in years)

An inline table valued function (iTVF) that can be used to calculate age in years.

Checking All Date Columns in a Table(s)

Find minimum and maximum values for all date columns in a table or range of tables, using a mask.

Date Format

Returns your date in the format mask you require.

Date Calendar

Code to create a handy date calendar cross-reference table with a ton of pre-populated, slice-and-dice data field variations to aid in complex date parameterization / selection criteria.

Return X Day of Month

This function will return the first, second, third, fourth or last day of a given month.