This is a way to get current financial year using SQL query:
- DECLARE @FIYear VARCHAR(20)
- SELECT @FIYear = (CASE WHEN (MONTH(GETDATE())) <= 3 THEN convert(varchar(4), YEAR(GETDATE())-1) + '-' + convert(varchar(4), YEAR(GETDATE())%100)
- ELSE convert(varchar(4),YEAR(GETDATE()))+ '-' + convert(varchar(4),(YEAR(GETDATE())%100)+1)END)
- SELECT @FIYear AS F_YEAR
Rinka SaiPosted Jan 13, 2020, 12:07 AM
I want to get Financial year start date and end date in the current year like 01-04-2019 (start date) and 31-03-2020
Pradeep KumarPosted Sep 19, 2017, 6:41 AM
Very useful. thankq sir for this post.
Piyush GoriyaPosted Apr 3, 2015, 4:46 AM
it is a nice to find the current finance year..using SQL ....
NitinPosted Mar 10, 2015, 3:31 AM
nice