>This does not work. The last value is an empty DateTime. How do I do this? What if the date is "20080819" or "08192008" or "08/19/2008" or whatever? Is there one way to convert these?
>
>
>cDate = '080819'
>cTime = '1315'
>cDateTime = cDate + ':' + cTime
>? ctot(transform(cDateTime,'@R ^99/99/99:99:99'))
>
cDate = '080819'
cTime = '1315'
cDateTime = cDate + ' ' + cTime
?cDateTime
? ctot(transform(cDateTime,'@R ^99/99/99T99:99:99'))
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.