I'm trying to locate a formula for Crystal Reports that will adjust a non-business hour/min/ss timestamp to the the next day. If the time portion of the timestamp is > 5:00:00PM and <= 11:59:59PM then the Date should increment by 1 day if day of week = 2(monday, this increment will be different depending on day of week) and the time should read 8:00:00AM.
Example: Timestamp = 2012,01,01 6:00:00PM - Adjusted time should read 2012,01,02 8:00:00AM
If the Timestamp = 2012,01,02 1:00:00AM - Adjusted time should also read 2012,01,02 8:00:00AM
Thanks for any help you can provide