How can I convert text "07JAN2007 hh:mm:ss" to date format

P

Pat

I imported data from text file (.txt) the field contains date in the format
like "10JAN2007 10:30:45". I want to reformat it to be a field that is able
to calculate date and time. How can I do?

Thanks,
Pat
 
Top