>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.
-Arne
arne@synercom-edi.com "There are no absolutes but this one."
President, synercom/edi - Event Ticketing Solutions