Master Calendar

kakani87 — Wed, 11 Jul 2018 07:36:34 GMT

Hi Folks ....

Am having knowledge in implementing master calendar.

When it comes to considering financial year FY in our project we consider 01-04-2018 to 31-04-2019 as Indian financial year

So for that to display calendarfinancialyear we consider date(YearStart(tran_date,0,4),'YYYY') as calendarFY

in the above statement 4 represents april month , now my question is why to consider 0.

when i use this in list box expression as date(YearStart(tran_date,0),'YYYY') gives 2019 and date(YearStart(tran_date,4),'YYYY') gives 2023

But this date(YearStart(tran_date,0,4),'YYYY') gives 2018 which is correct.

Can some one clear my doubt.

Regards,

Kakani.

Re: Master Calendar

Miguel_Angel_Baeyens — Wed, 11 Jul 2018 09:06:47 GMT

The second parameter of YearStart() is how many years you want to return back or in advance:

YearStart(Today(), -1) will be 01.01.2017

YearStart(Today(), 10) will be 01.01.2028

You need the 0 because you cannot leave a blank in the second parameter. 0 refers to the current year in the date.