• Posting the same question multiple times doesn't help you get to the right answer, it just fragments the responses you get.

    You don't store dates in SQL Server formatted as anything. That's a display function. Date/time values are stored as decimal values. Do a search of the BOL for dates, and the CONVERT and CAST functions.

    Don't store dates as strings!