This is an example script from my toolkit that helps me to quickly review the various different ways of performing date math in sql server.
Demo available here
