Hi

Bit of a prob !
I have two tables , when I transfer the date field in table one which is a text field ( looks like this 20000801 ) into the table two which is waiting to recieve the data and the date field here is set up as a proper date with the format
yyyymmdd , but the text date never gets written to the sister field. Why wont it do this and can I get round this ?
How ?

This is also happening when I try to import my linked table ( which is linked to a text file ) into my real table. The same thing ! the text date can't be witten to the date formatted field.

Thanks
Locutus