OK, there are 2 issues to discuss with concerning with date formatting:
1) formatting date on MS SQL Server side,
2) formatting date on client side using VB.NET, C# or any other .NET programming language
ad 1)
To format date on server side, see
SET DATEFORMAT statement[
^]. Note: there are some restrictions.
I would recommend you to use
ymd
format - see H.Brydon solution/recommendation ;)
ad 2)
Formatting date in VB.NET or C# is simple. See this:
Custom Date and Time Format Strings[
^].
Summary:
If you can get the date and string-date-format from database, you can do everything what you want to do ;)
To change string-date-format for DateTimePicker, see this:
Displaying a Date in a Custom Format with the Windows Forms DateTimePicker Control[
^]
Is it enough for start?