Need to extract distict month name from a date column.
Found something like this
SELECT DISTINCT Format(appointmentdate,'mmmm') AS distinctmonth
but it does not work.
Please advise.
Found something like this
SELECT DISTINCT Format(appointmentdate,'mmmm') AS distinctmonth
but it does not work.
Please advise.