Hi Tim,

can you use the TTOD() function? TTOD(DATETIME())=DATE()

>Hi,
>I am looking for a simple solution to remove the time portion of a date time.
>The problem is I select from an Oracle DB with SQL passthough and I recieve
>always the time portion and the users don't want this. I need to be able
>to change this without extensive coding for example with a SET TIMEPART OFF
>or SET DATE command as apposed to a valid,refresh coding syntax.
>Any ideas?
>
>TIA
>BR
>Tim