Date formating in Report

[opgenoort]

Hi,

I made a report with our Workstation's WarrentyDate and PurchaseDate.
In the report the date is formatted as 05/06/2009 00:00:00, with causes each record to take 2 lines.
I just need 05/06/2009, without the time, as shown also in the report builder.

How can I change this?

Thanks for your input in advance.

[Hemoco]

You can use a formatting function in your sql.
This might help you : http://www.sql-server-helper.com/tips/date-formats.aspx