Imported date format wrong

[bens]

I have imported data in to a text field in the format: 2006.09.29

The format should be: 29/09/2006

Does anyone know how i change it ? it's 120000 records.

[IdealData]

Use the Replace field contents with the following calculation

Middle ( TextDate ; 9 ; 2 ) & "/" &

Middle ( TextDate ; 6 ; 2 ) & "/" &

Middle ( TextDate ; 1 ; 4 )

This assumes that years are 4 digits, months are 2 digits and days are 2 digits.