Using HXTT Text driver
select CDATE('21111947','ddMMyyyy')
returns message
>[Error] Script lines: 1-2 --------------------------
CDATE('21111947','ddMMyyyy') has an error parameters list
Cheers,
Martin
|
select CDATE('21111947','ddMMyyyy') from test
?CDATE('21111947','ddMMyyyy') can work normally.
>CDATE('21111947','ddMMyyyy') has an error parameters list
It means that you're using an older package. Since v2.3.014, HXTT Text provides CDATE(expression,pattern) for date conversion.
|
oh! I will D/L latest again
Thanks!!!
|