Format DOB

[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.

 

[Rick B]

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

 

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