Please provide CREATE TABLE, INSERT INTO statements with sample data, so we have something to work with. It is very tedious to convert sample data from your post into actual populated SQL table.

It seems that you want to see what happened on given date. However, it may turn out to be more complicated. If you want more than to see "What was each driver doing on given day", then tweaking table(s) design may be in order...

I'll be back tomorow morning, Eastern Time.