Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Aug 2002
    Location
    St. Charles, Illinois
    Posts
    222
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Change date format (Access 2000)

    I am using a date field in a report. How do I take off the day of the week? I want the date to read, May 6, 2004, not Thursday, May 6, 2004. Thank you.

  2. #2
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts

    Re: Change date format (Access 2000)

    Open the Report in Design view, and find the format property of the control that displays the Date.

    Set the format to be mmm d, yyyy

    If you want months with long names (eg September) to have the full month written out use four m's.

    mmm will display as Sept .
    Regards
    John



  3. #3
    3 Star Lounger
    Join Date
    Aug 2002
    Location
    St. Charles, Illinois
    Posts
    222
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Change date format (Access 2000)

    Thank you.

Posting Permissions

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