Thank You for your reply.

I need records for user selected date. In this example I'm using 4/7/14.

The shifts are;

grave = 11pm to 7am

day = 7am to 3pm

swing = 3pm to 11pm

thanks