Master calendar Error

[#1]

Master calendar Error ...... could u please explain me the script error and if possible give me a possible script

[its_anandrjs]

Try to load your script like

Let varMin = Num(Date#('01-01-2014','MM-DD-YYYY'));

Let varMax = Num(Date#('07-13-2014','MM-DD-YYYY'));

LOAD

date($(varMin)+IterNo()-1) AS Date

AutoGenerate 1

WHILE $(varMin)+IterNo()-1<= $(varMax);

[its_anandrjs]

And for your script that you use right now make some changes convert the input date values into the dates then it works fine see the load script

LOAD

Date(Date#('01-01-2014','MM-DD-YYYY') + IterNo()-1) AS Date

AutoGenerate 1

WHILE  Date#('01-01-2014','MM-DD-YYYY') + IterNo()-1 <= Date#('07-13-2014','MM-DD-YYYY');

[its_anandrjs]

And there is one more way of doing the same but with NUM function

LOAD

Date( Num('01/01/2014') + IterNo() - 1) AS Date

AutoGenerate 1

WHILE  Num('01/01/2014') + IterNo() - 1 <= Num('07/13/2014');

Hi Manoj,

Without closing any thread do not open the new thread which is similar to the question until that completes just a suggestion for you look the below thread and close if got correct or helpful.

Master calendar question | Qlik Community

Regards

Anand