I'd appreciate some help on this, as I'm stuck.

I've have an excel workbook that uses macros to pull data from a company database. Almost all records have a date/time value associated with it.

Most date/time values use the format dd-mmm-yy hh:mm:ss (10-Dec-05 08:50:25)

My problem is that some tables are storing records in a similar format, but the values come out as 10-Dec-05 08:50:25.000
I'm trying to find records by more/less than queries, but it won't work with those zero values on the end.

How do I get rid of those three zeros on the end so that my macro recognises it as a date/time value?

Cheers,
Carl