Results 1 to 3 of 3

Thread: Change date to month in ACCESS
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular
    Join Date
    Jun 2012
    Posts
    70
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Change date to month in ACCESS

    I have a Complete Dt column with the date formatted as 10/8/2019 and I need a formula to convert this to the name of the month. Any ideas? I tried this but all I get is January in the column.


    Format(DatePart("m",[Completed Dt]),"mmmm")

  2. #2
    Board Regular Norie's Avatar
    Join Date
    Apr 2004
    Location
    Stirling, Scotland
    Posts
    75,191
    Post Thanks / Like
    Mentioned
    63 Post(s)
    Tagged
    6 Thread(s)

    Default Re: Change date to month in ACCESS

    Try this.
    Code:
    Format([Completed Dt],"mmmm")
    If posting code please use code tags.

  3. #3
    Board Regular
    Join Date
    Jun 2012
    Posts
    70
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Change date to month in ACCESS

    Great!! Thanks.. I tried that but, I was leaving the ) after the Completed Date was why it didn't work. Thanks again.

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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