Hi all,

I need to change the date,(or the reporting date), in a point of sale system to reflect a working day rather than an actual day. The system is in a restaurant and bar and as the bar may not close until after midnight on occasion, the invoices generated need to reflect that period. The date field however is an auto enter non modifiable field, as it should be. I can not think of an elegant way to bring these extra invoices in to the day's report. Can anyone point he way ?

I am unclear whether to kick the date (of weekend activity) forward or back. If forward to the next Monday, try this calculation (result is date) and generate your reports on it:

date + Position ( "17" ; DayOfWeek ( date ) ; 1 ; 1 )

UPDATE: If kicking the date back, use:

date - Position ( "71" ; DayOfWeek ( date ) ; 1 ; 1 )

Edited October 20, 200916 yr by Guest
Added update

Hi LaRetta, I think that I need to take the additional hours of the next day and add any invoices created then to the previous day so that if an invoice was created at 02:30 am on Wednesday, it would come out on the Tuesday turnover reports. The problem is that there are no set hours so it may be 1 hour after midnight or 7 hours after midnight and then there is the problem of Saturday as the restaurant is closed on Sunday

The problem is that there are no set hours so it may be 1 hour after midnight or 7 hours after midnight and then there is the problem of Saturday as the restaurant is closed on Sunday

Okay, then you need a set of business rules because the system can't determine the proper date if the open-for-business times change.

Have you considered a table where you can track date, time open and time end for your restaurant? That would make it possible to track and kick the receipts backwards if they are outside the standard business hours for that specific receipt date. Otherwise, you will need to come up with a standard set of 'open hours per day' for the business so you can apply the calculation to it.