WvR
asked on
Date result after 3 or 4 working days
Hello,
I have a request form and i want te get a speciale date.
In my database there is a table "closed"
In the table "closed" i entered some days when we are closed.
In my request form i want:
If the server time is < 10.00 AM the result should be today + 2 working days (not the weekend and not the closed days, if there is a closed day then the next working day).
If the server time is > 10.00 AM the result should be today + 3 working days (not the weekend and not the closed days, if there is a closed day then the next working day).
When there is a request in a weekend it should be monday + 2 working days (not the weekend and not the closed days, if there is a closed day then the next working day).
Could some one help setting this up???
Thank you,
HP van Hagen
WvR
I have a request form and i want te get a speciale date.
In my database there is a table "closed"
In the table "closed" i entered some days when we are closed.
In my request form i want:
If the server time is < 10.00 AM the result should be today + 2 working days (not the weekend and not the closed days, if there is a closed day then the next working day).
If the server time is > 10.00 AM the result should be today + 3 working days (not the weekend and not the closed days, if there is a closed day then the next working day).
When there is a request in a weekend it should be monday + 2 working days (not the weekend and not the closed days, if there is a closed day then the next working day).
Could some one help setting this up???
Thank you,
HP van Hagen
WvR
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.