Find next working day within the same period [message #675476] |
Tue, 02 April 2019 02:22 |
|
EPerry123
Messages: 2 Registered: April 2019
|
Junior Member |
|
|
Hi, I am reporting on daily orders taken, some orders happen on none working days i.e. weekends or bank holidays so I need to report those non working day orders against the previous working day OR if the period changes between the order day and the previous working day then I need to report those orders against the next working day. For example orders on Saturday 30/03/2019 need to show against Friday 29/03/2019 but if the Saturday had been 01/04/2019 then I would need to show the orders against Monday 03/04/2019. I figured out the first part but then discovered the second part, the period change as an issue. Does anyone have any ideas? Thanks
|
|
|
|
|
|