Importing time device entries for overnight shifts

Summary:

The client has numerous overnight shifts. The time collection device sends the time in and out entries on the dates they are entered. However, in Oracle, this is causing errors as the In is on a different date than the Out. The In time on the Monday doesn't have a corresponding Out time and the time entry on Tuesday is showing Out at 7 a.m. and an In at 11 p.m.

Example, an employee works 11 p.m. to 7 a.m. Monday to Friday.

The Monday employee punches In at 11 p.m. and on Tuesday the employee puches Out at 7 a.m.