TO MAKE FY YEAR FROM DATE

[abhaysingh]

I HAVE DATE.I WANT TO MAKE fINANCIAL YEAR

[kamalqlik]

Hi it can be done using function yearname.

Use like this Yearname(Datefield,0,4).

It will give the result for year starting from April and ending on March.

Regards,

Kamal

[abhaysingh]

I WANT YEAR LIKE 2012-2013,2013-2014,2014-2015

[#4]

Try the above function only

yearname(datefield,0,4)

[kamalqlik]

Hi Please Find Attached QVW.

Or simply use the code below.

LOAD * Inline

[

Date

1/23/2012

2/23/2012

3/23/2012

4/23/2012

6/23/2012

9/12/2012
10/23/2012

11/23/2012

3/23/2013

4/23/2013

6/23/2013

7/12/2013

];



Year1:

LOAD *,

Year(Date) as Year,

Month(Date) as Month,

YearName(Date,0,4) as FiscalYear

Resident Year;

Regards

KAmal

[er_mohit]

Hi in script side

you can write this where your date field exist like

Load Date,

yearname(Date,0,1) as FY_Jan,     //Year starts from Jan to Dec

yearname(Date,0,4) as FY_Apirl    //Year starts from Apirl to March

From Datasource;

[amit_saini]

Abhay,

Please see the attachments.

Thanks,

AS

[kamalqlik]

Hi Abhay,

In case your problem have been solved please close this thread by marking it as Correct or Helpful.

Regards

Kamal

[hic]

You should take a look at the article Fiscal Year.

HIC