Another way to bypass the usage of @today in view selection is:
1. Create a scheduled agent that runs once a day (0:01) that writes @Now to the server's NOTES.INI i.e.
ENVIRONMENT CurrentDateTime:=@Text(@Now);
2. In every selection formula that uses '@Now' use the code:
now:=@TextToTime(@Environment("CurrentDateTime"))
3. be sure that all view indexes rebuild every day after 0:01
One of the advantages is that no changes are made to the production templates by an nightly agent. Obiously this option also has a few disadvantages, such as using NOTES.INI variables etc.
Another way to bypass the usage of @today in view selection is:
1. Create a scheduled agent that runs once a day (0:01) that writes @Now to the server's NOTES.INI i.e.
ENVIRONMENT CurrentDateTime:=@Text(@Now);
2. In every selection formula that uses '@Now' use the code:
now:=@TextToTime(@Environment("CurrentDateTime"))
3. be sure that all view indexes rebuild every day after 0:01
One of the advantages is that no changes are made to the production templates by an nightly agent. Obiously this option also has a few disadvantages, such as using NOTES.INI variables etc.