>I have a temp table that for a particular UserID has CompletionDates of 10/24/2014, 08/02/2015, and 09/14/2015
>
>My command is
>
>Select Max(completionDate) from #TempTable where UserID = 9999999
>
>it returns the 2014 date, which makes my brain go 'bwuh?'
>
>What's going on here?

Two things....can you confirm the data type for the CompletionDate column? Just wondering if it's a character column instead of a date/datetime column.

If it's a character column, that's your problem.

If it's a date/tdatetime. are you absolutely certain that the values for 2014 are associated with the row where UserID is the 9999999?