
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Master Calendar error: "Field '<=' not found "
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?
- Tags:
- master calendar
Accepted Solutions


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thanks guys
you were right 🙂
