converting strings to dates in MS Access

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

Guest

I am trying to convert a string such as 071505 in a query in Access to a
date. I used all of the date built in functions in Access 2003 but none seem
to give me 7/15/05 or anything accurate. Any ideas?
 
You need to parse it first.
CDate(Left([YourTextField],2) & "/" & Right(Left([YourTextField],4),2) & "/"
& Right([YourTextField],2))
 
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

Which is the best MBOX Converter Tool different formats conversion? 4
#error - Blank 3
Convert a non date string to date format 3
Numeric Field Overflow when appending date - how to convert it to text 1
Convert mid month date to month end date 3
Convert Access SQL Query to Excel MS Query 1
Convert GPS Date and Time 2
Access pass-through query, SQL-92 combining strings: '&' does not 4

Back
Top