Results 1 to 3 of 3

Thread: Date Difficulty

  1. #1
    Join Date
    Feb 2003
    Location
    Cork, Ireland
    Posts
    4

    Unanswered: Date Difficulty

    I am using MS ACCESS 2000 and am having great difficulties with a date field and would greatly appreciate any help:

    SELECT Bulletins.Last_Status_Date, Bulletins.Status
    FROM Bulletins;

    This will return a date field like the one below:

    Last_Status_Date

    12/23/2002
    12/13/2002
    12/23/2002
    11/3/2002
    11/2/2002
    10/4/2002
    9/6/2002
    8/7/2002
    7/21/2002
    6/23/2002

    My question is: Is there any way to display the month that these dates come under instead of the full date...Like so
    Decemeber
    December
    December
    November
    October
    ''
    ''
    ''

    Regards pat

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    yes, format(Last_Status_Date,"mmmm")


    rudy
    http://r937.com/

  3. #3
    Join Date
    Feb 2003
    Location
    Cork, Ireland
    Posts
    4
    Thanks Rudy,
    I shall try this.

Posting Permissions

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