at first glance - are MinDate and Bookings::Date both defined as type Date ?
Default format of date in Filemaker is Systems' Date format (like MM/DD/YYY or MM/DD/YY). Please make sure the format of the fields which you are using to enter the data and find the data is same. Sometimes date formatting created problem.
But the date format is not the issue. You need to check Field Types in Manage | database | Fields. Your calculation field with the Min function should be of type calculation and when you open the specify calculation dialog, you should see that the result type is of type date as well.
Since this worked in a previous version of FileMaker we have to consider two scenarios: 1) The field type issue--maybe this was accidentally changed at some point and 2) The file may be damaged and the damage did not become observable until you converted the file to the new file format.
For 2, take a recent copy of your file and run a recover on it to check for damage. Then test the recovered copy to see if it works reliably when the original did not. (Do this even if FileMaker does not report finding an issue.)
Thanks for your responses. Yes, Bookings::Date is defined as a Date and the result of the calculation for Events::MinDate is set to Date. Phil, you may be on to something, it could be some sort of damage to the file after conversion.
For a particular record, I can copy the data from MinDate and in Find mode, paste the data verbatim back into MinDate and it returns no results. Search by EventNumber and the record shows up again. So something is not right. Hopefully i can get it sorted, the MinDate is an important field for populating some of the reports we generate.
Again, thanks all.
it could be some sort of damage to the file after conversion.
Minor quibble: I suggested that the file was damaged prior to conversion, but that it only affected behavior after conversion.