contiw
June 4th, 2004, 10:00 PM
Need to extract distict monthNames from date column.
This
------
SELECT DISTINCT (Format(appointmentdate,'mmmm')) AS distinctmonth
------
does not work. Please advise. ThankYou.
This
------
SELECT DISTINCT (Format(appointmentdate,'mmmm')) AS distinctmonth
------
does not work. Please advise. ThankYou.