Date format

[Michel Khennafi]

Good afternoon:

I have a field "ship date" in a table that is populated as follow
"05JAN2006" (DDMMMYYYY) and this field is a text field.

I would like to turn this field into a date field where I could make
calculations and REALLY have a date information.

I would like to add a column to the table and use an update query to
transfor the ship date into a real date... What is the function you would
recommend using to do so? Is there a better way than to add a column,
upodate and then remove one column?

Thanks

 

[Rick Brandt]

Good afternoon:

I have a field "ship date" in a table that is populated as follow
"05JAN2006" (DDMMMYYYY) and this field is a text field.

I would like to turn this field into a date field where I could make
calculations and REALLY have a date information.

I would like to add a column to the table and use an update query to
transfor the ship date into a real date... What is the function you
would recommend using to do so? Is there a better way than to add a
column, upodate and then remove one column?

Thanks

UPDATE TableName
SET DateFieldName = CDate(Left([ship date],2) & "-" & Mid([ship date],3,3) &
"-" & Right([ship date],4))