Hi all
Hope someone here can help me with my problem
I have a database called "returnsMySQL"
. Inside there are two tables called "originaldate" and tempdate".
The "originaldate" has dates but it is not a date type field. 3 Years ago the field started saving dates under the short date format.
Example:
9/2/13
In order to get correct searches, I need this field to be updated to the 4 digit year:
Example
9/2/2013
I have tried using Active Server Pages, querying the database and trying to format the results using "FormatDateTime" the get the correct date but I have not had any luck taking the formatted date and saving it to the field "tempdate"
.
There are about 15,000 records in the database.
What would be my best option to accomplish this?
Thank you very much for your time.