Unable to search in calculated field

[bigmac]

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?

[comment]

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.

[bigmac]

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

[bigmac]

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.

[comment]

Are you sure the result of your calculation is Date?

[bigmac]

yes, it's defenatly date

[The Shadow]

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, 2008 by Guest

[LaRetta]

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:

[bigmac]

Ok, here you go everyone.

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

test2.fp7.zip

[bigmac]

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

test2.fp5.zip

[The Shadow]

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

[comment]

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

[bigmac]

updating to 7.0v3 made it work -)

Thanks alot!!!!