Results 1 to 6 of 6

Thread: Date Question

  1. #1
    Join Date
    Dec 2003
    Posts
    138

    Unanswered: Date Question

    Is it possible to take a date [HireDate] and extract the Month from that date?

    I.e. if the [HireDate]=01/26/1978, then I want a field (separate from the HireDate field) to say January.

    Thanks!

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    Format(HireDate,'mmmm')
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  3. #3
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    ...or even
    =month(mydatecolumn)
    or
    =month(mydatevalue)
    I'd rather be riding on the Tiger 800 or the Norton

  4. #4
    Join Date
    Dec 2003
    Posts
    138
    Wow! How simple. I never even thought of that. Thanks!

  5. #5
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    healdem, the Month() function would return 1

    he wanted January

    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  6. #6
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    ooops I got as far as reading and then seemingly the blinkers set in.

    Is it possible to take a date [HireDate] and extract the Month from that date?
    I'd rather be riding on the Tiger 800 or the Norton

Posting Permissions

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