>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
>
>best regards!!
>
>
>AMG
Uh...
replace dt_date with date(val(left(tx_date,2)),val(substr(tx_date,3,2)),val(substr(tx_date,5)))
Something like that?
(Sorry if I typed anything incorrect. I've bought Microsoft's new Office kyboard and any time I think I press End I actually press Delete. Nice keyboard, but also terrible that they changed the pad above the arrows :(
Groet,
Peter de Valença
Constructive frustration is the breeding ground of genius.
If there’s no willingness to moderate for the sake of good debate, then I have no willingness to debate at all.
Let's develop superb standards that will end the holy wars.
"There are three types of people: Alphas and Betas", said the beta decisively.
If you find this message rude or offensive or stupid, please take a step away from the keyboard and try to think calmly about an eventual a possible alternative explanation of my message.