Hi, I am trying to run a job on the last working day of the month - I currently use
trunc(last_day(sysdate))+18/24
as the code, which finds the last day of the month fine. The problem occurs when the last day of the month is a Saturday or Sunday - if that occurs, I need to then bring the job forward forward to the Friday night.
I have tried using next_day with little success, and am stuck! I'm sure people need to set this up all the time ....I just can't seem to find how!
Thanx
Rob
trunc(last_day(sysdate))+18/24
as the code, which finds the last day of the month fine. The problem occurs when the last day of the month is a Saturday or Sunday - if that occurs, I need to then bring the job forward forward to the Friday night.
I have tried using next_day with little success, and am stuck! I'm sure people need to set this up all the time ....I just can't seem to find how!
Thanx
Rob