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

[laxmanqlik]

Thak you very much Shraddha,

it is very helpful,

how can we do the same if we have a date field  of "BILLDATE"

i tried financial year as yearname(Datefield,0,4) but its not working

[shraddha_g]

try

if date format of BILLDATE is DD-MM-YYYY then

yearname(Date#(BILLDATE,'DD-MM-YYYY'),0,4)

[laxmanqlik]

bill date in the format of MM-DD-YYYY,

i tried above the with yearname(Date#(BILLDATE,'MM-DD-YYYY,'),0,4)

but getting an error as UNKNOWN STATEMENT

[shraddha_g]

yearname(Date#(BILLDATE,'MM-DD-YYYY,'),0,4)

Is this comma is typo?

Try removing it

[laxmanqlik]

thanks sharddha,

tried the above but getting the same error

those the fields what we are using,

[shraddha_g]

There is comma missing before yearname statement