June 3, 2014 at 1:21 am
Hi Everyone,
I am using MSSQL Server 2008R2 and I am interested in returning rows from a 'financial' table that fall within the current year (each row contains a 'Entered Date'). I am located in Australia so my financial year consists of all entries between the date 01/07/xx to the 30/06/yy.
Can anybody suggest some code, perhaps using the datediff() function, or other functions as required to achieve what I need?
Kind Regards,
David
June 3, 2014 at 4:45 am
Calculate fiscal year in SQL Server
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
June 3, 2014 at 11:25 am
WHERE
[Entered Date] >= DATEADD(MONTH, 6, DATEADD(YEAR, DATEDIFF(YEAR, 0, GETDATE())
- CASE WHEN MONTH(GETDATE()) < 7 THEN 1 ELSE 0 END, 0)) AND
[Entered Date] < DATEADD(MONTH, 6, DATEADD(YEAR, DATEDIFF(YEAR, 0, GETDATE())
- CASE WHEN MONTH(GETDATE()) < 7 THEN 1 ELSE 0 END + 1, 0))
Edit: Split lines into two so all code is visible in the code window.
SQL DBA,SQL Server MVP(07, 08, 09) "Money can't buy you happiness." Maybe so, but it can make your unhappiness a LOT more comfortable!
June 4, 2014 at 12:18 am
Thanks for the very helpful responses.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply