Automatic date update (almost a workflow engine)

[trobia]

Hallo everybody,

I'd like to "dinamically" update a global date field with the current date; dinamically means that none has to click or digit or do nothing at all. The idea is the FMPRO itself should check the system date and update a field with the changed value, if that is the case. This has to happen continuosly, so that if while working, with the DB open, I'm passing the 23:59, my "gCurrentDate", so to speak, will have to have stored the correct value, without me having to update "manually". Any solution which doesn't possibly involve developing a plug in?

I've tried looping a script, but it locks FMPRO.

Thanks in advance, and I apologise for the lack of clarity, as I'm posting at night (as usually).

Carlo

P.S. No applescript either, not on xp...

[-Queue-]

Create a Time field that auto-enters Modification Time. Create a global calculation field of Left( TimeModified; 0 ) & Get(CurrentDate). It will update whenever a record is modified.

This is as close as you can get to having it automatically update. A change must be made on a record in the field's table.

If you are using a global, however, there's no reason not to use an unstored calculation field of Get(CurrentDate), which is already set up to work the same way.