>Hi there
>I have a table with a text field calle TX_date who has a value "02022001" saved
>i need to store that value in a DATE type field called DT_date to get 02/02/2001
>how can i get it
>thanks in advance
>

Take a look at CTOD() and DATE() functions.