Converting imported string dates to Date/Time

[ser01]

Hello!
I am importing a large amount of data from an HTML document into a table. There is a text field with dates in it and the format of the dates is

June 8 12:48:10 2010 EDT

How do i convert this to Date/Time? I have tried a lot of different ways in an update queries with no luck. Any help would be greatly apreciated.


Thank you

[dsmacs]

Try this formula in a query;-

FormatDateTime(Left([ConvDate],InStr([ConvDate],":")-4) & "," & Mid([ConvDate],InStr([ConvDate],":")+6,5) & " " & Mid([ConvDate],InStr([ConvDate],":")-2,8),0)

where convDate is the name of the field

Cheers
Darren

[ser01]

Try this formula in a query;-

FormatDateTime(Left([ConvDate],InStr([ConvDate],":")-4) & "," & Mid([ConvDate],InStr([ConvDate],":")+6,5) & " " & Mid([ConvDate],InStr([ConvDate],":")-2,8),0)

where convDate is the name of the field

Cheers
Darren

Works great, thank you so much...