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 |
|
Magua1
Starting Member
15 Posts |
 Posted - 2014-12-05 : 10:35:58
|
| I have a number of views which have hard coded dates in them.I would like to be able to replace these with code.Each academic year runs from 1st Aug to 31st July. How can I calulate which is the current academic year without hard-coding dates?TIA |
|
|
Muj9
Yak Posting Veteran
75 Posts |
Posted - 2014-12-05 : 11:15:43
|
| Can you provide sample data. |
 |
|
|
gbritton
Master Smack Fu Yak Hacker
2780 Posts |
Posted - 2014-12-05 : 12:29:54
|
| put the dates in a separate table and reference that table instead of the hard-coded dates. |
|
|
|
|
|
|
Academic year