I am coding about Rstaurant System. It have Shift which can open 17.00 to 2.00 of new day.(17:00 of 1 Aug to 2:00 of 2 Aug) But it remain be 1 day of working.
Although I can create Report by choosing each date with shift but I have problem about choosing Date Range by having Shift also.
Assume that I want to see 1 Aug to 5 Aug.. There are 2 Shift(17:00-21:00 and 21:01-2:00(new day))
It mean that (17:00 of 1Aug - (17:00 of Aug5 and 2:00 of 6Aug)) is what I will see in report.
Please reply me because it is Important. via email at email@example.com or talk your email to me...
So that I can contact you directly if you want more detail
I use MDB file is Database