date functions won't update w/out closing file

[DWR]

I have published a database to the web that requires relative dates (i.e. if requested_date > today). The database stays open on the web server 24/7, so the today function doesn't update (because the file doesn't close/open; apparently the status(currentdate) doesn't update either). Everything works fine, if I manually close/open the file once each day. Is there a solution other than a plug-in that triggers a script based on date/time?

[camcorp]

I have the same situation, and i haven't fix it yet, but thinking about it I beleive that a script can do this for you. My first Idea is using a Plugin that schedulle a date updatescript. ANother way to triger such script is using a web based triger. Maybe in an URL you can trigger the script using a refresh tag every 24 hours or maybe with a calculation field.

camcorp

[Keith M. Davie]

Try making it a calculation, unstored.

Yes ScriptMaker scripts are fine if you allow for multiple requests in a near-simultaneous manner. If not you risk problems.