Just to clarify, summer starts Memorial Day and ends Labor Day. I will post a teaser every Friday until Labor Day. Got this from my friend George, try to guess the output of the code below without running it.   SET DATEFORMAT DMY SELECT CONVERT(DATETIME, '120607')