Search results

Hello My last question was answered, how to extract a date/time range. What I need now is to take it one step further. I need to extract the earliest time logged for any given day. Example: 01/17/2005 0625 am 01/18/2005 0615 am 01/18/2005 0622 am...

Pat hartman / mresann Hay! Works great, Than you so much. Now if I can take this one step futher, to be able to return the earliest time stamp form each day. I would like to know by day when the employee logged on to our system. Thanks ;)

Sample data 01/05/2005 0555 am 01/05/2005 0600 am 01/05/2005 0625 am 01/05/2005 0631 am 01/05/2005 0657 am Example of data I need to query is a range of time value, ex: between 0600 am and 0645 am. The query would return a value of:01/05/2005 0600 am...

How, in a query can pull out a range of time values. I have data being inported that show activity in chronology order and what to pull out certain time ranges Date/Time format and data example: Field name: Date/Time Data: 01/02/2005 06:00 am