Issue in create master calendar

[Anonymous]

LET vStart = num('2014-01-01');

LET vEnd = num(('2014-01-01');

Master_Cal:

Load Date($(vStart) + RecNo(),'MM/DD/YYYY') as Date  autogenerate $(vEnd) - $(vStart);

When I am excute this script for each month it's showing from 1st to 31st.

I dont understan why it's not get right month end date.

[its_anandrjs]

Hi,

Write this way and your End variable is wrong might be it is 2014-01-31

LET vStart = num('2014-01-01');

LET vEnd = num('2014-01-31');

Master_Cal:

Load

Date($(vStart) + RecNo(),'MM/DD/YYYY') as Date

autogenerate $(vEnd) - $(vStart);

Regards

Anand

[saumyashah90]

How can you make start and end date as same????

[its_anandrjs]

Hi,

Or better you use

LET vStart = num('01/01/2014');

LET vEnd = num('12/31/2014');

Master_Cal:

Load

Date($(vStart) + RecNo()-1,'MM/DD/YYYY') as Date

autogenerate $(vEnd) - $(vStart);

Regards

Anand

[Anonymous]

It's just type error.

[Anonymous]

it's working fine now