status(currentdate) comparison

[jmkimmel]

We are using FMP 6.0v3 on Win 2000.

I have a date field that users put a date to follow up on items, it is stored as a date. I compare that to " status(currentdate)" in an IF statement and return either "Due" or "Not Due" based on the situation in a calculation. The user can then run a script that returns any items marked as "Due " .

Sounds like it should work without fail if the calculation field evaluates every time that the referenced field changes its value, but it doesn't. There are some records that do and some that don't. I can't even see a pattern in when it does or doesn't evaluate.

I can periodically fix it by running a script that I created that goes through each record and copies the value in that record and pastes it right back on top of itself.

FMP Help just talks about making sure that they are the same data type when you compare.

Can anyone tell me why this is happening?

[kennedy]

Make sure your "Due" field is set to "unstored" in Storage Options so that it gets re-evaluated whenever you display/use the value. You generally do not want to store the value of calcs that use Status functions.