Data Base: oracle
I want to create a caluclated column for ship date and req ship date
I am using the following syntax
(_days_between ([ship Date],[Req Ship Date]))
but I want to exclude saturdays/sundays/holidays
for eg:- aug 11 is the req date, aug 8th is the shipped date
the difference between these two dates is 3 days
but answer should be 1 day ( Aug 9 and Aug 10 are holidays)
appreciated for your reply
If it is just the weekend you want to skip , then a calculation may be in order.
However, holidays are irregular.
The best solution is to use a calender file with a counter that increments for each regular working day.
You can design this in a spreadsheet and upload it to a table for reference purposes..