Date formatting

[Taboka]

Hi all,
My question is as follows:I have a list report with columns Date,Product Name and Count.The date is in format 28 Nov, 2007, 12:01:40 AM,28 Nov, 2007, 12:01:56 AM,etc.Now because there is a time difference on the same date,Product Names are repeating on the same date as well.I want a Product name to appear once per day.I have tried to format the date using the to_date and to_char functions,but to no avail.Could somebody perhaps point me in the right direction,

Thanks\Regards

Taboka

[rockytopmark]

Use EXTRACT() function to retrieve parts of the timestamp, and piece those parts into a Date only query item.

[lastsummer]

You can use function like this
Cast(YourTimestamp, DATE)

[Taboka]

Thank you both for your assistance  ;D

Cheers

Taboka