I rec'd a large data base with date and time together. The date is incorrect based upon the "time" shown. Let me explain. The time value is a total of time from the event to the time of a report. As example
7/8/2013 72:80:00
is actually
7/6/2013 8:27 am or 8:20 am

The 72:80:00 is left on the column.
Thanks