|
|
|
 |
Overclock.net - Overclocking.net > Software, Programming and Coding > Coding and Programming | |
Beginof Week Conversion
|
||
 |
|
|
LinkBack | Thread Tools |
10-19-09
|
#1 (permalink) | |||||||||||||
|
2 + 2 = 5
 
Join Date: Nov 2006
Location: In a Chair.
Posts: 34,975
Rep: 4174
  Unique Rep: 1909
Trader Rating: 56
|
Beginof Week Conversion
I am building a SQL Server Reporting Service report. I would a way to pass in a single date and return the Monday of that date's week.
i.e. I pass in any date between 10/04/09 and 10/10/09, it returns 10/05/09. Any suggestions? The formula has to be within a single text box.
__________________
To answer most of your questions: (1) a fridge cannot cool a PC (2) 64-bit OS for over 3.4GB (3) If a PCIe card fits, it should work (4) Resolution, not screen size (5) If you have a question, it is not news (6) Report, not respond to Spam (7) Single-Rail/Non-Modular PSUs are not always better than Multi-Rail/Modular
|
|||||||||||||
|
|
|
10-19-09
|
#2 (permalink) | |||||||||||||
|
2 + 2 = 5
Join Date: Nov 2006
Location: In a Chair.
Posts: 34,975
Rep: 4174
Unique Rep: 1909
Trader Rating: 56
|
Nevermind... got it solved.
date1='10/7/09' =dateadd("d",2-datepart("w",date1),date1)
__________________
To answer most of your questions: (1) a fridge cannot cool a PC (2) 64-bit OS for over 3.4GB (3) If a PCIe card fits, it should work (4) Resolution, not screen size (5) If you have a question, it is not news (6) Report, not respond to Spam (7) Single-Rail/Non-Modular PSUs are not always better than Multi-Rail/Modular
Last edited by DuckieHo : 10-19-09 at 01:36 PM |
|||||||||||||
|
|
|
|
| Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | |
|
|
