This just may be to simple, but for me the easiest way to manage date based views is to have an agent in the database that updates all documents with the current date, runs once a night...
The contents of the agent are:
FIELD tim_CurrentDate := @Today ;
"";
I simply include this agent in any database that needs date based views and reference tim_CurrentDate in the selection formula... If for some unknown reason the agent doesn't run in a db, I just re-run it manually and everything is fine. That has only happened 1 or 2 times in over 5 years of using this technique...
This just may be to simple, but for me the easiest way to manage date based views is to have an agent in the database that updates all documents with the current date, runs once a night...
The contents of the agent are:
FIELD tim_CurrentDate := @Today ;
"";
I simply include this agent in any database that needs date based views and reference tim_CurrentDate in the selection formula... If for some unknown reason the agent doesn't run in a db, I just re-run it manually and everything is fine. That has only happened 1 or 2 times in over 5 years of using this technique...