In FMP6 i had a date field calculated as follows:

todays date + 10, 20 or 30 days (value list dependent)

I also had a script that could find over due dates, ie

/

This field used a not-stored calculation that was immediately recalculated if necessary.

In fmp7 it is no longer possible to do this search unless i store the calculations first. How do i solve this issue?

There shouldn't be a problem searching in an unstored calculation field. Please post the exact calculation formula, as you have it in version 7.

The calculated field is the payment_due_date

It is calculated with a very simple formula:

credit_days + invoice_date

Calculation is unstored

I use the search mode to search for over due dates, ie /

No work unless I store the calculations. This worked great in fmp6, but as soon as I converted it to fmp7 it broke

in fact, it's not possible to search in that field at all.

Example:

I go back to an old invoice dated 2007-01-21.

I copy that very date, enter find mode, paste that date in the Payment_due_date field and press find.

No records found when I know I'm looking at it... very strange.

Are you sure the result of your calculation is Date?

yes, it's defenatly date

If you are using date formatting on the field, and your native date format isn't "2007-01-21", then you will need to use your native format in find mode for that field.

No, that can't be it, that wouldn't explain "/" not working.

Edited January 13, 200818 yr by Guest

There is something unclear here for sure.

This: todays date + 10, 20 or 30 days (value list dependent)

... is not the same as

This: credit_days + invoice_date Calculation is unstored

There is no need for this calculation to be unstored if the fields both reside in the same table/file. So how does todays date enter into it? Was it using the Today() function? Does the calculation itself reside in another file?

Or you might have converted to vs. 7 and have a broken reference (the credit days resides elsewhere?) Anyway whatever the reason, we'll need to see your file, I think. :wink2:

Ok, here you go everyone.

try to search for the "due date"... good luck -)

test2.fp7.zip

and, here, the exact same thing but in filemaker 5/6, and here it works great.

test2.fp5.zip

Seems to work fine with FileMaker 9, using your File's date formats. I am able to search for both a specific date and "/".

Have you patched your application to 7.0v3 (or whatever the latest patch for Windows was)?

updating to 7.0v3 made it work -)

Thanks alot!!!!