Matching date values .. in query

[edmscan]

I would like to match the following date values .... the User is a text field .. and LastUpdate is a DateTime type.

What is the best way to find a match of these 2 dates ? I need to find in my query .. dates/times that match. Because I get the data from an outside source ... I cannot alter the way I get the data.

Thanks ..
Kevin

User	Radio	LastUpdate
New: 2014/06/23 13:09	728	2014/06/23 1:09 PM
New: 2014/05/20 23:44	800	2014/05/20 11:44 PM
New: 2013/09/04 16:41	840	2013/09/04 4:41 PM
New: 2014/07/10 22:29	894	2014/07/10 10:29 PM
New: 2014/04/19 21:46	991	2014/04/19 9:46 PM
New: 2014/05/25 03:35	1080	2014/05/25 3:35 AM
New: 2013/08/17 20:57	1125	2013/08/17 8:57 PM

I don't know quite for sure .. if I have covered it. But this is what I have so far ... I will have to determine if I have all the possible date / time values.

[AnandKhinvasara]

Does User have value as "New: 2014/06/23 13:09" inside it ? ... I mean is "New" part of the value.

[June7]

Can't alter the way data is sent but can control how it is fed into the table. Do you get the data in a CSV file?

Judging by the query, "New: " is part of the data.

Suggest you format the date/time in one field.

Format(Mid([LastUpdate],6), "yyyy/mm/dd hh:mm")

Review thread with similar issue. https://www.accessforums.net/access/...mns-45569.html

[edmscan]

Thanks .. and yes New: is part of the data, and yes the data is in a csv file.

I can actually alter the "User" data in the csv file .. so it is possible to make it like the LastUpdate field. It is written in C .. so I can change it. But it is not really a big deal.
It is almost easier just dealing with it in Access. I may do this in the future.

I will take a look. We are not talking a lot of records .. like less than 150 right now and that is not likely to grow much at all. Those 150 records have been from the last 10+ years.

But I did have to make some changes from the above. Added .. CDate, and looked thru the records manually and I seem to have them all.

Thank you for your help. I will probably look at this later today or in the next few days.