Some Common Date Routines

I'm sure that these routines are available in a variety of locations, this just adds one more place that people can find them if they need them. These are some common routines for generating commonly needed dates. I hope people find them useful in MS SQL Server.