Text format to Date format

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

When my table was set up and data first entered, the "Date Started" field was
a text field. I went through all my records and entered a specific date in
the format "dd/mm/yy", and then changed the format to "Date" with the "short
date" input mask. When I saved the table design, all my records disappeared.
Fortunately I saved it to a different name so I didn't lose all my records,
but how can I change from text to date without losing everything?

Thanks for any info.

KK
 
You don't do it directly. Instead, create a new field as date/time type.
Then run an update query to copy the date values from the text field to the
date/time field. Then delete the original text field.
 
Back
Top