SitePoint Sponsor

User Tag List

Results 1 to 2 of 2

Hybrid View

  1. #1
    SitePoint Enthusiast
    Join Date
    Apr 2004
    Location
    Fountain Valley, California
    Posts
    35
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    MSAccess Query Select Distinct Date

    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.

  2. #2
    SQL Consultant gold trophysilver trophybronze trophy
    r937's Avatar
    Join Date
    Jul 2002
    Location
    Toronto, Canada
    Posts
    39,323
    Mentioned
    63 Post(s)
    Tagged
    3 Thread(s)
    i'm sorry, but that does work, i just tested it

    any chance you could explain how it doesn't work for you?

    was there an error message? did it return anything? did it return something other than month names?

    what is the datatytpe of your appointmentdate column?
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL
    "giving out my real stuffs"


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •