I have two questions to ask :

I had a field set as (date/time) in my MS Access database

I placed a drop down list on my page and added a datasource. what I wanted to do is to display in the drop down list :

1-Only unique dates and order them by day / month / year
2-Ignore the time

So my statement was :

SELECT DISTINCT MyDateField from table order by MyDateField asce

What I'm getting is a list of distinct dates which great, but each date is followed by time : AM 12:00:00

any idea how I can get red of the time !

Secondly the date doesn't appear correct , it changes the day to month and month to day like:

1/12/2007 is changed to 12/1/2007

any idea also why this happened ?