|
-
Mar 5th, 2012, 12:09 PM
#1
Thread Starter
Fanatic Member
Function to get 2 dates
SQL Server 2008
I am writing some sql for an academic institution.
Some of the sql must extract records between 2 dates.
These dates represent the beginning and end of the academic yesr.
Basically if the current date is before the 1st Sept then the start date will be the 1st Sept last year and the end date the 30th Sept this year else it will be the 1st of Sept this year and the 30th next year.
How can I get these dates?
Thanks in Advance
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|