topic Re: How to represent a financial calendar in App Development

How to represent a financial calendar

laxmanqlik — Wed, 16 Nov 2016 06:35:40 GMT

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

Re: How to represent a financial calendar

shraddha_g — Wed, 16 Nov 2016 06:39:36 GMT

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

Re: How to represent a financial calendar

laxmanqlik — Wed, 16 Nov 2016 06:45:27 GMT

i dont have date field,

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

Re: How to represent a financial calendar

shraddha_g — Wed, 16 Nov 2016 06:58:02 GMT

What is the format of month?

Re: How to represent a financial calendar

laxmanqlik — Wed, 16 Nov 2016 07:08:48 GMT

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

Re: How to represent a financial calendar

shraddha_g — Wed, 16 Nov 2016 07:19:19 GMT

See attached.

It might help.

Re: How to represent a financial calendar

laxmanqlik — Wed, 16 Nov 2016 07:26:32 GMT

sorry

i didn't find any attachment here

can you send again

Re: How to represent a financial calendar

shraddha_g — Wed, 16 Nov 2016 07:32:35 GMT

PFA

Re: How to represent a financial calendar

laxmanqlik — Wed, 16 Nov 2016 08:40:07 GMT

sorry Shraddha,

i am not getting any attachment here

Re: How to represent a financial calendar

shraddha_g — Wed, 16 Nov 2016 08:42:06 GMT

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

];

Re: How to represent a financial calendar

laxmanqlik — Wed, 16 Nov 2016 10:22:00 GMT

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

Re: How to represent a financial calendar

shraddha_g — Wed, 16 Nov 2016 10:29:51 GMT

try

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

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

Re: How to represent a financial calendar

laxmanqlik — Wed, 16 Nov 2016 10:47:48 GMT

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

Re: How to represent a financial calendar

shraddha_g — Wed, 16 Nov 2016 12:21:52 GMT

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

Is this comma is typo?

Try removing it

Re: How to represent a financial calendar

laxmanqlik — Wed, 16 Nov 2016 12:32:34 GMT

thanks sharddha,

tried the above but getting the same error

those the fields what we are using,

Re: How to represent a financial calendar

shraddha_g — Wed, 16 Nov 2016 15:06:51 GMT

There is comma missing before yearname statement