HELLO!

I worked up the attached calculation that works off getting current date and comparing to set deadline date, resulting in a user intuitive label. Example; "Due Today, Tomorrow, Wednesday, Etc..."

I would like to use this calculated label... BUT!.. I have a concern:

Sense the calculation works of the Get (CurrentDate) it will not have a correct result unless it has in real time got the CurrentDate. Example; deadline field was set sometime in the past and record was then viewed sometime in the future, label would not have correct results unless forced to re-check real time CurrentDate.

How can I keep this from happening?

Maybe...

I could run a script that forces an update upon opeing file, but there will be thousands of records to check. Plus, this fmp solution is shared over a network, constantly running on a server, never closed. Note: running FMP only, not server.

Is any of this practical? Is there an easy way?

THANKS for any help!

:)

Make the calculation unstored.

Make the calculation unstored.

Simple enough, I just do not have much experience and did not know if I could trust the "[X] Do not store calculation" to work properly.

Thank you for the reinsurance!!!

Well, it will work properly in the sense that it will recalculate whenever the screen is refreshed. OTOH, if you're just sitting and staring at the screen, it will not switch by itself come midnight.

Not that this would likely happen, but to ensure, I could attached a script trigger to the deadline field, to run a housekeeping refresh script when modified.

Tho the modify it's self would prompt the calculation to update, never mind.

Edited October 16, 201213 yr by Dr. Evil