Announcement

Collapse
No announcement yet.

MsAccess Query, Extract Distict monthName

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • MsAccess Query, Extract Distict monthName

    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.
Working...
X