Convert text to date format

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

Guest

How would I convert the text string '2004-01-19-13:15:30' to a date format? I am assuming I would use the cdate function, I am just not sure how it would look. Thanks for your help!
 
How would I convert the text string '2004-01-19-13:15:30' to a date format? I am assuming I would use the cdate function, I am just not sure how it would look. Thanks for your help!
Click to expand...

Hm. As I feared, the hyphen between the day and the hour messes this
up. This works:

?cdate("2004-01-19 13:15:30")
1/19/2004 1:15:30 PM

So I'd suggest the rather contorted approach below. Assuming that this
string date is in a Text field named sDate, use

CDate(Left([sDate], 10) & " " & Right([sDate], 8))
 
You must log in or register to reply here.

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

Convert date serial from text to date value 4
Windows 7 I need to convert date to text 3
Change text format to date format 2
Problem formatting dates from CSV file 2
Converting Date to Julian 4
Extracting a date value from memo field, different locations in memo 2
convert text to date 12
Date Formatting 1

Back
Top