How do I convert a text value to a date in MS Access 97

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

Guest

I have a field in a table that is text in the format of yyyymmdd. I need to
convert this data to a date format (mm/dd/yyyy).
 
I have a field in a table that is text in the format of yyyymmdd. I need to
convert this data to a date format (mm/dd/yyyy).
Click to expand...

Your date looks like this "20050810" ?

=DateSerial(Left([FieldName],4),Mid([FieldName],5,2),Right([FieldName],2))
 

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

Text to date format? 0
Excel date format YYYYMMDD 1
International Date Values - Access 2007 3
printing report with date 3
convert date 1
Date Conversion 5
Changing date in number format to dd/mm/yyyy? 5
Date Formatting 1

Back
Top