How get TOP 10 DISTINCT dates

[Guest]

I have a table with a date/time field. I need to get the top 10 distinct
dates (ignoring time portion). I tried:

SELECT DISTINCT TOP 10 Format(RecordDate,'MM/DD/YYYY') AS RecDate
FROM tblAddress
ORDER BY Format(RecordDate,'MM/DD/YYYY') DESC;

but it gave me all the same dates.

How do I do it?

 

[Michael Gramelspacher]

I have a table with a date/time field. I need to get the top 10 distinct
dates (ignoring time portion). I tried:

SELECT DISTINCT TOP 10 Format(RecordDate,'MM/DD/YYYY') AS RecDate
FROM tblAddress
ORDER BY Format(RecordDate,'MM/DD/YYYY') DESC;

but it gave me all the same dates.

How do I do it?

maybe this is all it would take:

SELECT TOP 10 Format(RecordDate,'MM/DD/YYYY') AS RecDate
FROM (SELECT DISTINCT RecordDate FROM tblAddress) AS t
ORDER BY Format(RecordDate,'MM/DD/YYYY') DESC;

 

[Guest]

Try this --
SELECT DISTINCT TOP 10 CVDate(Int([RecordDate])) AS Dates
FROM tblAddress
ORDER BY CVDate(Int([RecordDate])) DESC;