HOW DO I ALTER THE DATE FORMAT??

[JONBOY74]

Hi All

I've got a table that contains a field which has dates in it. What I need is for those dates to been shown like YYYYMMDD (20010601) and not 06/01/01. The data comes from an Oracle database. How can I turn the inserted dates into the format I require.

Thanks

Jon

 

[nickjar2]

Hi Jon,

Try something like:
UPDATE Table1 SET Table1.Field3 = Year([field2]) & Month([field2]) & Day([field2]);

Where field3 is your Date field, and Field2 is your new Text field.

Nick