General information
Category:
Coding, syntax & commands
I would try something like this:
replacde DOB with ;
date(val(substr(tmp, 1, 4)), val(substr(tmp, 5, 2)), val(substr(tmp, 7, 2))) ;
in clients
Hope it helps
Oscar
>Hi,
>
>This is simple, I know. But I can't figure it out.
>
>I am trying to replace a date field (date of birth) with a character value. The character value is as follows:
>
>19650824
>
>I have SET DATE TO YMD for this and I use the CTOD() function to do the conversion from character to date. However it is returning a blank date.
>
>Tmp="19650824"
>Replace Client.DOB with CTOD(TMP)
>
>What am I doing wrong???????
>
>
>Thanks.
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only