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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Windows 7 I need to convert date to text 3
How to convert OST to PDF? Simple Methods 4
Importing dates from fixed-width text files to Access 2007 7
Best Ways to Convert OST to PDF? 3
Date format change 4
Converting seconds to hh:mm:ss 2
Format Date in Report 1
change data type from text to date/time 1

Back
Top