I am getting this error on an object with date type. It contains a date with timestamp which is a timestamp datatype. Any function to convert this to date type only.
GC_hill 
(BOB member since 2007-08-29)
It would help if you tell folks what database platform and version you are using, since objects are defined in the universe with the appropriate database functions.
Anita Craig (BOB member since 2002-06-17)
I am using oracle database.
GC_hill (BOB member since 2007-08-29)
Try taking a look at this past topic.
Hint: Do a search on one or more most likely keywords - that’s how I found it, searching on timestamp 
Anita Craig (BOB member since 2002-06-17)
I met this before. What I did ( of course, learnt from BoB 
) is to use Cast ( Timestampe as date ) function. After converting, I’m able to use trunc,…, these functions. that Designer supports.
You may have a try.
Bonita (BOB member since 2008-03-04)