format date field

[gray78]

I have downloaded a log (.txt) file off a server and imported it into an access table. The format of the date/time field from the log is as follows:
[12/Oct/2005:13:26:04
and
- [12/Oct/2005:13:28:2

I want to convert it to a mm/dd/yyyy format. How can this be accomplished?

Thanks

 

[KenReay]

Hi

Make a new field of type date/time, with format property "mm/dd/yyyy", in your table. Make an update query to update the new field with the content of the incomming text field. Use CDate() function to convert the text to a date type, and Mid() to extract the relevant bits of the text field.

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK