Issue Loading in TempCalendar

[#1]

Dear QVExperts,

I am facing an issue.

LET varMinDate = '09/01/2008';

LET varMaxDate = '05/31/2013';

//DROP Table Temp;

TempCalendar:

LOAD

Date('$(varMinDate)' + IterNo() - 1) as TempDate

AutoGenerate 1

While '$(varMinDate)' + IterNo() -1 <= '$(varMaxDate)';

If execute this script, the dates should be loaded till 31st May 2013.

But it loads only till 28th May 2011.

It is surprising. Can you please suggest me.

Thanks

Sasi

[#2]

Even i try this,

LET varMinDate = '09/01/2008';

LET varMaxDate = '05/31/2013';

//DROP Table Temp;

TempCalendar:

LOAD

Date('$(varMinDate)' + IterNo() - 1) as TempDate

AutoGenerate 1

//While '$(varMinDate)' + IterNo() -1 <= '$(varMaxDate)';

While IterNo() <= '$(varMaxDate)' - '$(varMinDate)' +1;

But inserted till 28th May 2011.

Thanks,

Sasikumar

[tamilarasu]

Sasi,

Try this,

LET varMinDate = Num(Date#('09/01/2008','MM/DD/YYYY'));

LET varMaxDate = Num(Date#('05/31/2013','MM/DD/YYYY'));

TempCalendar:

LOAD

Date('$(varMinDate)' + IterNo() - 1) as TempDate

AutoGenerate 1

While '$(varMinDate)' + IterNo() -1 <= '$(varMaxDate)';

[Kushal_Chawda]

You need to use Date# to recognize the variable value as numerical

LET varMinDate = floor(date#('09/01/2008','MM/DD/YYYY'));

LET varMaxDate = floor(date#('05/31/2013','MM/DD/YYYY'));

//DROP Table Temp;

TempCalendar:

LOAD

Date('$(varMinDate)' + IterNo() - 1) as TempDate

AutoGenerate 1

While '$(varMinDate)' + IterNo() -1 <= '$(varMaxDate)';

[#5]

Hello Tamil,

THanks.

Still the same.

Please find enclosed the screenshot.

[#6]

Thanks Kush. Still the same. It loads till 28th May 2011.

Sasi

[Kushal_Chawda]

see may attached app

[Anonymous]

Hi Sasi ,

Your script is working fine for me .

LET varMinDate = date#('01/09/2008','MM/DD/YYYY');

LET varMaxDate = Date#('05/31/2013','MM/DD/YYYY');

//DROP Table Temp;

TempCalendar:

LOAD

Date('$(varMinDate)' + IterNo() - 1) as TempDate

AutoGenerate 1

While '$(varMinDate)' + IterNo() -1 <= '$(varMaxDate)';

[tamilarasu]

Sasi,

It's working fine. Check the attachment.

[rwunderlich]

Please post the Document Log so we may see what your script is doing.

-Rob