Converting date/time to date in designer

[cw48371]

Hi,

I am really struggling to convert a SQL date/time field to a pure date dd/mm/yy field in BO designer, I'd really appreciate any ideas other than changing the field in SQL. I need this to be able to group approriately in BO client.

Craig

 

[jimbopalmer]

trunc(my_table.my_date) will make the date always occur on midnight so trunc(sysdate) = '08/06/02' works I tried to remain child-like, all I acheived was childish.