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.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 Academic year

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.
Go to Top of Page

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.
Go to Top of Page
   

- Advertisement -