Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2003
    Location
    Oxford, England
    Posts
    38

    Unanswered: Get the month from a date field

    Hi,

    There's probably a really simple asnwer to this but i cant seem to find it.

    I have a date field and i want to display just the month in words.

    At the moment i have

    DatePart(m,PressreleaseDate) AS stMonth

    but that returns a value of 1-12, i want January to December

    can anyone help

    Regards,

    Luke

  2. #2
    Join Date
    Dec 2003
    Location
    Oxford, England
    Posts
    38

    Re: Get the month from a date field

    Nevermind i've worked it ut

    Datename(month,([PressreleaseDate])) as 'MonthName'

    Easy!

Posting Permissions

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