How to represent a financial calendar

[laxmanqlik]

hi Every one,

i have a requirement that i have to represent the data of particular financial year like Apr2015 to Mar 2016

can any one let me know the way to do that

thanks in advance

[shraddha_g]

If you have date field then calculate financial year as yearname(Datefield,0,4)

[laxmanqlik]

i dont have date field,

i have month,year,sales,quarter and so...

[shraddha_g]

What is the format of month?

[laxmanqlik]

it like jan, Feb .......

[shraddha_g]

See attached.

It might help.

[laxmanqlik]

sorry

i didn't find any attachment here

can you send again

[shraddha_g]

PFA

[laxmanqlik]

sorry Shraddha,

i am not getting any attachment here

[shraddha_g]

Script used in app

Load *, yearname(monthstart(Date#(Month &' '& Year , 'MMM YYYY')),0,4) AS DateField;
Load * inline [
Month, Year
Jan,2016
Feb,2015
Mar,2016
Apr,2016

];