error when reloading

[#1]

I am getting a script line error when reloading my qvd file. the error message is in the image attached

[simenkg]

That was my intention. anything happening after the Exit Script; statement will not happen.

Now right-click the MinMax-table and click preview and show me the results

[#3]

Unable to preview

[simenkg]

That means it's empty, which is a result.

This means that the problem is in the creation of the MinMax table. I need to know the format of the ServiceDate to continue.

[#5]

is this what you need?

[simenkg]

Yes, Thanks.

Try to replace the tab with the text in this document.

The only change is from

[MinMax]:

Load

  Min(ServiceDate) as MinDate

  ,Max(ServiceDate) as MaxDate

Resident

  [CensusFact];

to

[MinMax]:

Load

  Min(Date(ServiceDate,'MM/DD/YYYY')) as MinDate

  ,Max(Date(ServiceDate,'MM/DD/YYYY')) as MaxDate

Resident

  [CensusFact];

I hope this works.

Remember to remove the Exit Script; line if you only pasted the changes

[#7]

still getting 3 script line errors

Script line error:

[TempCalendar]:

Load

  Date(''+RowNo() - 1) as TempDate

  AutoGenerate

  (''-''+1)

--------------------------------------------------

Table not found

[MasterCalendar_Census]:

Load

  TempDate                               as ServiceDate

  ,WeekStart(TempDate) as WeekStart

  ,Month(TempDate)                        as Month

  ,Year(TempDate)                         as Year

  ,Day(TempDate)                          as Day

  ,'Q' & Ceil(Month(TempDate) / 3)        as Quarter

  ,Date(MonthStart(TempDate),'MMM YYYY')  as MonthYear

Resident

    [TempCalendar]

Order By

    TempDate Asc

--------------------------------------------------

Table not found

DROP TABLES statement

[simenkg]

I made a mistake in the previous post:

[MinMax]:

Load

  Min(Date#(ServiceDate,'MM/DD/YYYY')) as MinDate

  ,Max(Date#(ServiceDate,'MM/DD/YYYY')) as MaxDate

Resident

  [CensusFact];

Try it.

[#9]

Same errors as above.

[simenkg]

Hmm. I'm afraid this requires some deeper analysis than I am able to do over the discussion thread.

As a workaround you can try to replace the lines

Let vMinDate = Num(Peek('MinDate',0,'MinMax'));

Let vMaxDate = Num(Peek('MaxDate',0,'MinMax'));

With
Let vMinDate = Num(YearStart(MakeDate(2012)));

Let vMaxDate = Num(YearEnd(Today()));

[#11]

Still didn't work, I Thank you so much for all your help