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 |
|
nightmare207
Starting Member
1 Post |
 Posted - 2011-06-25 : 12:45:04
|
| hello to all!i have a problem and i need your help.I have a date.from this date i want to find the week which it belongs.spefific, i want to find the week range.but the problem is that i don't want the typical week range.take an example so you can understand better.month=junefirst week of the month : 30/05/11 - 03/06/11last week of the month: 30/06/11 - 3/06/11so,i want this...last week of the may : 23/05/11 - 31/05/11first week: 01/06/11 - 10/06/11last week: 27/06/11 - 30/06/11in the others words..if the first day of the month is Wednesday or Thursday or Friday then these days go to the next week.if the last day of the month is monday, Tuesday ,Wednesday then these days go to the previous week.thank you very much!! |
|
|
|
|
|
help with bussiness week