Convert text string to date

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

Guest

How do you convert a text string, "112905" to a date of 11/29/05?

So it has the appropriate serial value 38685 for 11/29/05.

Thanks in advance
 

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

Problem formatting dates from CSV file 2
Calculating the difference between two dates if two criteria are m 3
Time and the Max Function 15
Access MS Access Concatenate a date and text field 16
Date format problems after csv import 2
Averageifs & median 1
Calculating pay dates 4
DAYS360 4

Back
Top