create a master calender with time and take it as input for selection

[#1]

i have to get the data from my table using start and stop date using in our table and i have written a code but it is not working giving error that field not found.

please correct the code if you find any error.

MinMaxDates: 

LOAD Floor(Min(TimeStamp#(START_DATE, 'DD.MM.YYYY hh:mm'))) AS MinDate,  

     Floor(Max(TimeStamp#(END_DATE, 'DD.MM.YYYY hh:mm'))) AS MaxDate 

RESIDENT R_DELAY; 

LET vMinDate = FieldValue('MinDate', 1); 

LET vMaxDate = FieldValue('MaxDate', 1);  

CalendarTemp: 

LOAD DayStart(TimeStamp($(vMinDate) + (RecNo()/60/24) + (IterNo() -1))) AS AddedDate, // Use this one as date  

     TimeStamp($(vMinDate) + (RecNo()/60/24) + (IterNo() -1)) AS AddedTimeStamp 

AUTOGENERATE 86399 WHILE $(vMinDate) + IterNo() -1 <= $(vMaxDate);

DROP TABLE MinMaxDates;

[Gysbert_Wassenaar]

Make sure R_DELAY contains the fields START_DATE and END_DATE. Qlikview is case sensitive with regards to field names so START_DATE, Start_Date and start_date are all different fields to Qlikview.

[Anonymous]

I do this by:

• Creating a normal date calendar
• Creating a time table by autogenerate() 'ing  the hours & minutes
• Then outer joining them both together

[#4]

Dear Gysbert,

thanks for the reply. I have the same field name in correct case. But still I m getting the error.