Calendar

[#1]

Dear All,

I have create a calendar by getting help from this forum. But I cannot see my last 2 date in the calendar. Can someone explain the reason of this? Please see the file attached.

Best Regards,

[#2]

Hi,

What I can see is that the largest year loaded into your calendar is 2008 and this way the orders for 2009 and 2010 are not associated with the other dates. I'm not sure, but as far as I can see the reason is the TempCalendar code. If you do not drop the table at the and of the script you will see that the last date loaded is in 2008, no 2009 and 2010.

That's all I can help you with for now. I know it is not a solution, but I hope it will help you atleast a bit to find your errors.

Best,

Maya

[pdumas · Accepted solution]

Hi,

Your Peek statement reads the first (01.11.2000) and last record (04.11.2008) of your inline table.

If you place the actual maxdate (01.01.2010) on the last position of your inline table, your calendar will be complete

Regards

Pierre.

[#4]

Hi Pierre,

In my calendar file, I solved the problem with your suggestion. Now it works fine in standalone mode. When I integrate this code to my existing file I have below error message:

What can be the reason of this error. Why it is not calculated ?

Hope to hear you soon.

Best Regards,

[pdumas]

Hi Asim,

Your dates now are timestamps with Date+Time.

In that situation, the variables mus be written between quotes

Please try this :

LOAD
 '$(varMinDate)'+IterNo()-1 AS Num,
 Date('$(varMinDate)'+IterNo()-1) AS TempDate
AUTOGENERATE 1 WHILE '$(varMinDate)'+IterNo()-1<= '$(varMaxDate)';

Pierre.