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
If you have date field then calculate financial year as yearname(Datefield,0,4)
i dont have date field,
i have month,year,sales,quarter and so...
What is the format of month?
it like jan, Feb .......
It might help.
i didn't find any attachment here
can you send again
i am not getting any attachment here
Script used in app
Load *, yearname(monthstart(Date#(Month &' '& Year , 'MMM YYYY')),0,4) AS DateField;Load * inline [Month, YearJan,2016Feb,2015Mar,2016Apr,2016
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
if date format of BILLDATE is DD-MM-YYYY then
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
Is this comma is typo?
Try removing it
tried the above but getting the same error
those the fields what we are using,
There is comma missing before yearname statement
Retrieving data ...