Probably the most clean way to do this is have a second table (with the date for example) that you use as a link in your order records. Then add a ‘correction’ number field to the parent date table too.
In your orders table simply select the date from your second table, do a lookup to the correction field and subtract it from the auto number with a function.
This way you would only have to add a correction value once a day.
