date conversion

[Elaine]

I have text field,which contains date in follow
format "Wednesday, August 27, 2003 4:15:57 PM". I need to
convert this field in date/time format. Is it possible?

Thanks

 

[John Nurick]

Hi Elaine,

Add a date-time field to the table. Then use an update query containing
an expression like this to convert the text field to a date/time value
to update the new field, where XXX is the name of the text field:

CDate(Mid([XXX], Instr([XXX],", ") + 2))