Thank you for your post.
Since it was working previously, something has obviously changed. From your description, it is difficult to determine.
Try taking the file off the server and use it locally. Are you able to find successfully? If not, then either the field or the database is damaged. Try creating another calculation field using the same MAX calculation. Does this work? If not, then the file may be damaged.
Try using a backup of the file before the calculations started failing. Make sure the Find works properly, and then import the data from the suspect file.
Please keep me updated with any progress.
I made another field using the same formula and it had the same problem. Then I made the field just a plain date field and tried "replace field contents" with the calculated result of the same MAX formula. Instead of a date, where it had a result it filled all the fields with slightly different number strings on each record (for example, 733728) all six numbers in length. When I formatted for a date, they all came out 0/00/000.
Thank you for testing.
If another calculation with the same formula produces the same error, then the file may be damaged. Run a Recover on the file, open the Recovered file, and see if the problem persists. If not, then use an older copy of the file and input the data from the damaged file.
Yes, replacing a field with the MAX formula does cause a number value, and our Development and Software Quality Assurance (Testing) departments are aware of this issue. You can see another post with this problem at:
Please continue to keep me updated with your progress.
Also developed a problem with the console not running. Rebooted the server last night. Files all went through validation OK. Came in this morning before anyone else and the problem wasn't there. The find takes awhile, but returns correct results.
Thanks for the update, and I'm glad everything is working.
If you run into this same problem again, close the database files manually before rebooting. Then you won't have to worry about possible file corruption and validation. To do this, launch the Mac utility "Terminal" and enter the following command:
You can then follow this with:
fmsadmin stop server
Then, reboot the server.