Find next working day within the same period [message #675476] |
Tue, 02 April 2019 02:22 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/177d3437b273f755145ee5c59e2067bf?s=64&d=mm&r=g) |
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
|
|
|
|
|
|