Formating / removing data from fields

[Moss100]

Please could someone assist.

I have an old diary that I want to convert to access format.

When I export it and open it in access, the records in the field 'STARTDAT':

1998-04-02 10:00:00.000000000 (STARTDAT is currently formatted as a text field - if i try to change this to date field it deletes all the receords. I have manually changed one recording removing the 9 zeros and then it will accept a change to date format - so I guess I need a way to trim the end of the records).

I would ideally like ot to be reformatted to 10.00.00 02/04/1998

What is the best way to do this - there are 60000 records

Many thanks Mark

 

[PHV]

I'd use an update query:

UPDATE yourTable SET STARTDAT=Left(STARTDAT,19) WHERE Len(STARTDAT)>19

And then you may alter the column to type DateTime.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886