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

W

wko

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

Sharkbyte

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))
 
Top