I've never had to do this. Would it help if you had 2 computed date columns that had a DEXTRACT of the start and end? I'm assuming you have 2 DateTime columns now? Because then if the 2 DEXTRACT columns are the same then you can simply do math of the time; if not then you add together 2 times, from beginning to midnight and then from midnight to end.
Can't think of anything more elegant... Karen -----Original Message----- From: Tom Frederick <[email protected]> To: karentellef <[email protected]> Sent: Fri, Mar 4, 2016 12:35 pm Subject: [RBASE-L] - Midnight shift notes We have to track activity by shift and write a note for record purposes. All notes have a staff ID, topic, actual note, date and start/end times which provides proof of activity. Right now I can bill activity by a whole day, but a change to billing by the hour is coming. For day and evening shifts it is pretty easy. They stay same day and within a consecutive time frame. Overnight shifts have to deal with Midnight date/time changes to automatically split over two dates and make 24 hour clock time adjustments. I can check for overlap or bad start/stop times within the same date. Making adjustments for Midnight date/time is just not clicking in my head. Any suggestions are welcome. Tom Frederick President/CEO Elm City Center 1314 W Walnut Jacksonville, IL 62650 O-217-245-9504 F-217-245-2350 [email protected]<mailto:[email protected]>
