Date format
Database
2
Posts
2
Posters
0
Views
1
Watching
-
Can anyone explain me how to convert a date with the format YYYYWWD (where WW is weeknumber an D is day (1 for Monday, 2 for Tuesday, 3 for Wednesday, 4 for Thursday, 5 for Friday) to YYYYMMDD.
An obvious way would be to find out which day number January 1 of the given year was, then add WW lots of seven days. SQL Server's date manipulation functions are capable. Stability. What an interesting concept. -- Chris Maunder