how we can increase and decrease financial year value

sudheer kumar

12y1.2k.NET

how we can increase or decrease the value of financial year. means suppose that financial year is 2013-14 and we want to next 5 or next 10 year of given financial year or previous 5 or 10 years of that financial year what is the code for that

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Jignesh Trivedi12y ago

hi,
try...
string CurrentYear = "2013-14";
int currentYearNumber = int.Parse(CurrentYear.Split('-')[0]);
int j = 10;
List pyear = new List();
List nYear = new List();
for (int i = 0; i <= 10; i++)
{
    pyear.Add(String.Format("{0}-{1}", currentYearNumber - j, ((currentYearNumber - j + 1) % 100).ToString().PadLeft(2,'0')));
    nYear.Add(String.Format("{0}-{1}", currentYearNumber + i, ((currentYearNumber + i + 1) % 100).ToString().PadLeft(2,'0')));
    j = j - 1;
}
List final = pyear.Union(nYear).ToList();
In final list you get all previous and next year....
hope this will help you.
0
Vulpes12y ago
Try this method.

Although it's ASP.NET, I've used a console app for illustration:

using System;

class Program
{
static void Main()
{
string[] finYears = GetFinancialYears("2013-14", 5, true);
foreach(string finYear in finYears) Console.WriteLine(finYear);
Console.WriteLine();
finYears = GetFinancialYears("2013-14", 10, true);
foreach(string finYear in finYears) Console.WriteLine(finYear);
Console.WriteLine();
finYears = GetFinancialYears("2013-14", 5, false);
foreach(string finYear in finYears) Console.WriteLine(finYear);
Console.WriteLine();
finYears = GetFinancialYears("2013-14", 10, false);
foreach(string finYear in finYears) Console.WriteLine(finYear);
Console.ReadKey();
}

public static string[] GetFinancialYears (string currentYear, int number, bool inFuture)
{
string[] items = currentYear.Split('-');
int year1 = int.Parse(items[0]);

int increment = inFuture ? 1 : -1;
int i = 1;
string[] finYears = new string[number];

while (i <= number)
{
year1 += increment;
finYears[i - 1] = String.Format("{0}-{1}", year1, (year1 + 1) % 100);
i++;
}

return finYears;
}
}

The output is :

2014-15
2015-16
2016-17
2017-18
2018-19

2014-15
2015-16
2016-17
2017-18
2018-19
2019-20
2020-21
2021-22
2022-23
2023-24

2012-13
2011-12
2010-11
2009-10
2008-9

2012-13
2011-12
2010-11
2009-10
2008-9
2007-8
2006-7
2005-6
2004-5
2003-4

If you want the second year to always be two digits (e.g. 2008-09 rather than 2008-9), then change this line:

finYears[i - 1] = String.Format("{0}-{1}", year1, (year1 + 1) % 100);

to this:

finYears[i - 1] = String.Format("{0}-{1:D2}", year1, (year1 + 1) % 100);

0