Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Adianjali
Starting Member
7 Posts |
 Posted - 2011-01-06 : 01:38:28
|
| In my table there is registeredby_date column which is displaying the date present in the database and now using this date i want one more column(calculated field) for my report which will display that date is which week of the year. Monday to Sunday is to be calculated as 1 weekExample 1st(saturday) and 2nd(Sunday) Jan 2011 is 1st Week of the year and 3rd Jan to 9th Jan will be 2nd Week and so onarjun.s |
|
|
nathans
Aged Yak Warrior
938 Posts |
|
|
|
|
|
Date as which week of the year