>>Hi Arne,
>>
>>One correction...

DatePortion = DTOC(DateTimeFieldName_InCursor)

>>I believe you meant TTOC Because SQL returns a DateTime, right?
>>I use TTOD() to convert where required.
>>HTH,
>
>Bill,
>
>actually, I did mean DTOC because Doug only wanted the date portion returned. DTOC(DATETIME()) will return just the date portion as CHAR. TTOC will return the whole DATETIME as CHAR.
>
Hi Arne,
Well, you learn something new every day! I guess I didn't read the help close enough as it says you can pass in a date or datetime. (One more into the bag of tricks!)