How to get a date without the time of the day

[#1]

I have something like this in my script:

date(date#(RetireDate,'DD/MM/YYYY'),'DD/MM/YYYY') as RetireDateDate,

But when I show this on a report table it shows 20/03/2009 12:00

How to get rid of the 12:00?

[#2]

I'm just showing it on a table column.

Any way I tried to add the field to a listbox and there are no duplicates...I don't see what's the problem you're having with the duplicates....

[Jason_Michaelides]

Well you've successfully confused me anyway...

As long as you have the desired result I guess.