Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
How can you make start and end date as same????
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
It's just type error.
it's working fine now