Results 1 to 4 of 4
  1. #1
    3 Star Lounger
    Join Date
    Mar 2006
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    289
    Thanks
    0
    Thanked 1 Time in 1 Post

    MonthName equivelent in Access 97

    Can anyone tell me what is the equivelent to the MonthName function in Access 97? I need to convert the integer month to text.
    Thanks
    chuck

  2. #2
    Administrator
    Join Date
    Jun 2010
    Location
    Portugal
    Posts
    12,519
    Thanks
    152
    Thanked 1,398 Times in 1,221 Posts

  3. #3
    3 Star Lounger
    Join Date
    Mar 2006
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    289
    Thanks
    0
    Thanked 1 Time in 1 Post
    Sorry, I wasn't clear that I am using Access 97. Access 97 does not recognize the MonthName function but it must have a way to convert 12 to December.

    Got it! You use the Format function. Format([aDate],"mmmm").
    Last edited by chuckrau; 2012-12-13 at 18:54.
    Thanks
    chuck

  4. #4
    Administrator
    Join Date
    Jun 2010
    Location
    Portugal
    Posts
    12,519
    Thanks
    152
    Thanked 1,398 Times in 1,221 Posts
    Sorry, don't know if there is one, but it can be very quick and easy to write a replacement.

Posting Permissions

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