Date Issue

I am on sql 2008 R2.

Lead is not recognized. I am guessing that is a 2012 function.

Thanks for the suggestion.