A simple SQL query will do.

Thanks for the idea.

I could easily do that, but I am concerned about teaching a client to directly change data.  I guess I could do it for them.

But you're fixing the wrong problem.  The users need to pay attention and enter the dates correctly in the first place.

I agree, but it doesn't help fix the three year history report by day.  Currently after the report is generated, manual entries are made to correct the data.

Write or get written a very simple front end that updates the SQL data for the date on a single invoice.  Only give the CFO / boss the interface. They will be annoyed every time they have to use it which will lead to an enhanced user learning curve.

I like that answer.

Thanks.