error when reloading

[#1]

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

[martynlloyd]

As SKG mentioned, you do not have a date in your weekend functions.

[simenkg]

Look under the tab called Census Calendar.

It would be the logical place for it.

[#4]

nvm that last post

I found it here

[simenkg]

Try changing $(vMaxDate) to '$(vMaxDate)' and post the new error message if it crashes again.

if this does not fix the issue, then the line
Let vMaxDate = Num(Peek('MaxDate',0,'MinMax'));
returns an empty value. If that is the case we need to see where the MinMax-table is defined.

[Anonymous]

What Simen is saying that makes sense. You try to change your definition something like below

In your case, it seems vMaxdate is not able to compute data and it becomes empty, so weekend() is throwing error. PLease check separately, if there is indeed any data returned from vMaxDate from log file.

[#7]

It looks like that ran but I am getting another error.

[simenkg]

This is the same error. Simply change  $(vMaxDate) to '$(vMaxDate)' in the whole sheet and see if that fixes it.

[#9]

next error

[simenkg]

Did you do the same for the vMinDate variable?

eg. change $(vMinDate) to '$(vMinDate)'

[#11]

Simen, I appreciate all your help thank you very much. But I am having trouble fixing this script below. I dont know where the correct place for brackets are.