-
August 27th, 2012, 04:30 PM
#1
Adjusting Time in CR
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|