Need to extract the distinct monthName.
The closest I could get is

SELECT DISTINCT (Format(appointmentdate,'mmmm')) AS distinctmonth

which of course does not work. Please advise.