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 |
|
lucsky8
Posting Yak Master
105 Posts |
 Posted - 2009-01-26 : 10:13:40
|
| HI,What the best way to compare a date to check if that date in a school year.Keep in mind a school years is 2007-2008,2008-2009Start september end june-The user enter a date in the table. as datUser-The begining of the year start in september year XXXX. as datSart-The end june year XXXX as datEnd-datToday as server dateSo how to take datUser and datToday and make sure it between datStart and datEndAny idea or suggestion?tks in advance i hope i exmplain my self write. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-01-26 : 10:16:45
|
| WHERE GETDATE() BETWEEN datSart AND dateEnd |
 |
|
|
|
|
|
Compare date for school year