Date format

M

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
 
R

Rick Brandt

Michel said:
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
Click to expand...

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