Below is a sample of the records I need to split by 12 hour shift. The records for 10/21 and 10/14 span at least two shift I am charge with creating Crystal Reports that detail in formation by shift. My reports will look back more 12 months, I am stumped. It seems I need to create a temp table for the current report range with a records each shift date and time and then loop through the delays records pulling out delays portions for each shift.
DOES ANYONE HAVE A BETTER IDEA? Or any suggestions would be rewarded.
DELAY_START DELAY_END DATE DELAY_MINUTES
10/21/2011 6:00:06 10/22/2011 23:40:06 21-Oct-11 1439.9
10/16/2011 6:00:02 10/16/2011 18:00:05 16-Oct-11 720.05
10/14/2011 7:30:15 10/15/2011 22:38:25 14-Oct-11 1349.75