Master Calendar error: "Field '<=' not found "

[roisolberg]

Hi All,

I encountered an odd error,

when loading my master calendar i receive an error "Field '<=' not found "

the weird thing is that i am using the same calendar in several models and it works fine.

i have searched the community and saw suggestions of changing the order of the script but it does not seem to work.

any ideas?

[Mark_Little · Accepted solution]

Hi
Looks like your max date variable is not being populated for some reason.
Add a trace statement after the lets.

Trace max date $(vMAxDate);
When you run the script you should see the value in the variable.

Mark

[sunny_talwar · Accepted solution]

If you look closely, your FactEntities table have fetched 0 records and minmaxdate is blank...

Since, there is no row in minmaxdate... the variables are empty. You need to figure out what is going on with you minmaxdate table or even better would be to check FactEntities table.

[roisolberg]

Thanks guys

you were right 🙂