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

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).
 
G

Guest

Check the Help Files, for syntax, but I'm pretty sure the command is CDate.

HTH

Sharkbyte
 
F

fredg

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
convert date 1
printing report with date 3
Date Conversion 5
Changing date in number format to dd/mm/yyyy? 5
Convert Date 1
Date Formatting 1

Top