Date & Leading Zeros 2

[lenebene]

Hi! I have a table of 700,000 records. The date currently is formatted 5/25/1987. I need the date updated to look like this 05/25/1987. This needs to be done so that I can import it into Oracle.

Thanks!

 

[PHV]

What is the data type of the field ?
If (as it really should) DateTime then simply play with the Format function in a query and then export this query to Oracle.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[lenebene]

This is a table thou... I don't want to create a query if I don't have to... is there another way to do this?

Thanks!
Charlene

 

[Golom]

In design view for the table, set the Format for the field to "Short Date" then, in "Control Panel / Regional & Language Options / Customize / Date ", set the "Short Date" format to "MM/dd/yyyy".

Assuming of course that it is a DateTime field.

 

[lenebene]

oooo that will work. Thanks!