Changing date format

[michaelc80]

I have a table populated with several thousand records-one field is a date field in the format of 5/5/2006. I have to change the data so that it is 5/05/2006 in order to import it into a SQL table.

I'm sure there has to be an easy way to do it, but I can't come up with it. Changing the imput mask on the field affects future data input but does not change what is currently there.

Any ideas or suggestions?

Thanks!

 

[KeithG]

Use the format function.

 

[RuralGuy]

If it is really a date field then you can just use the Format() function to present the data in *any* format you wish.