Min DateTime for Each Day
I have a security access log and I want to find the earliest time entry for each day. I have one DateTime field.
DateTime Access
2014/05/14 08:23 Door #1 Opened
2014/05/14 08:56 Door #1 Opened
2014/05/14 12:15 Door #1 Opened
2014/05/14 18:23 Door #1 Opened
2014/05/15 08:59 Door #1 Opened
2014/05/15 08:56 Door #1 Opened
2014/05/15 12:15 Door #1 Opened
2014/05/15 18:23 Door #1 Opened
All I want is the first record for each day. Is this possible? Thanks!!