• Thanks for you suggestion Scott. I have added the following and it seems to do the same thing:

    SELECT DISTINCT CONVERT(DATETIME, MonthEnding, 106) AS MonthEnding

    FROM Sales