Try:
lc='2001-01-18 09:34:58'
?ctot(substr(lc,6,2)+"/"+substr(lc,9,2)+"/"+substr(lc,1,4)+substr(lc,11))

>Is there any possible way to allow fox to accept a string for a DateTime field. I have a radius program that formats the DT as '2001-01-18 09:34:58'
>In the INSERT statement, it's passed as a string - this is hardcoded in the radius - to the odbc driver. Any ideas?
>
>Thank you!
>
>Christopher