Format DOB

B

Brig

I have a table with the DOB field.

However, all the entries in this field are in 021404 format that I want to
change to 2/14/04.

Let me know on how can this be done.

Thank you.
 
R

Rick B

A date field stores a serial number equal to that date. You can use the
format option to change how it displays.
 
D

Douglas J. Steele

What's the datatype of the DOB field? If it's Date, then what Rick says is
true. However, if it's numeric or text, you should probably add a date field
to the table and convert those values to dates.

If they're always 6 digits, you can use something like
DateSerial(Right([TextDOB],2), Left([TextDOB], 2), Mid([TextDOB], 3, 2))
 
Top