Hello All,
Need a help on the below condition.
Working hours : 9:00 AM to 5:00 PM
Example 1:
Starting Date : 8/1/2012 9:31 AM
Expected Result: 8/2/2012 5:00 PM
Example 2:
Starting Date : 8/3/2012 9:31 AM
Expected Result: 8/6/2012 5:00 PM
Example 3:
Starting Date : 8/1/2012 5:31 PM
Expected Result: 8/3/2012 5:00 PM
Example 4:
Starting Date : 8/1/2012 5:31 AM
Expected Result: 8/2/2012 5:00 PM
Basically if the Starting time falls between the working hours, then the expected result will go end of next business day. Also if the starting time falls in the weekend then technically Start time should begin from Monday 9:00 AM from there expected result will be Tuesday 5:00 PM.
Regards,
Naveen
Need a help on the below condition.
Working hours : 9:00 AM to 5:00 PM
Example 1:
Starting Date : 8/1/2012 9:31 AM
Expected Result: 8/2/2012 5:00 PM
Example 2:
Starting Date : 8/3/2012 9:31 AM
Expected Result: 8/6/2012 5:00 PM
Example 3:
Starting Date : 8/1/2012 5:31 PM
Expected Result: 8/3/2012 5:00 PM
Example 4:
Starting Date : 8/1/2012 5:31 AM
Expected Result: 8/2/2012 5:00 PM
Basically if the Starting time falls between the working hours, then the expected result will go end of next business day. Also if the starting time falls in the weekend then technically Start time should begin from Monday 9:00 AM from there expected result will be Tuesday 5:00 PM.
Regards,
Naveen