Text format to Date format

[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

 

[Ken Snell [MVP]]

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.