Master Calender issue....

[#1]

Hi guys,

Please explain me the following code written for creating master calender...

Load

RecNo()-1+Floor(MakeDate(2012)) As TempDate

AutoGenerate(730);

..

[nilesh_gangurde · Accepted solution]

Hi,

The Record number Function will generate the value like 1,2,3,4,5,6,.........730

now, for 1st Record generation:

((1-1)  + 1 jan 2012 ) as TempDate

means your first record will have 1 jan 2012 as TempDate.

then for 2nd record:

((2-1) +  1 jan 2012) as TempDate

here your second record will have 2 jan 2012 as TempDate.

and this is upto 730 records because in autogenerate function you kept the limit for 730.

-Nilesh

[#3]

Thanks Nilesh....

Regards,

Sachin