Format DOB

  • Thread starter Thread starter Brig
  • Start date Start date
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.
 
A date field stores a serial number equal to that date. You can use the
format option to change how it displays.
 
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))
 
Back
Top