Hard Drive Crash - Date issue after reinstall

[CatPG]

Hi there,

We run FileMaker 9.  Our server crashed, and we had to reenter about 10 days of data. Yikes - I know

After the re-entry of data, I had to edit the dates of the re-entered items to match the original dates.  After doing that, the new date entered isn't being recognized by our sales report scripts.  For e.g. I re-entered orders from May 5th,  The order date was May 12th, the date they were re-entered.  I then when back and changed those orders to May 5th to match the original dates.  When I run any sales report, it says there are no orders for May 5th.  They are being added to the May 12th reports instead.

I'm at a loss...Any help would be greatly appreciated!!

Thanks!

 

[Ron Cates]

It sounds like the report is searching on a date created field rather than the date ordered field. I would check the script or relationship that dictates the found set and make sure it is using the date ordered field.