Results 1 to 11 of 11
  1. #1
    ineuw's Avatar
    ineuw is offline Advanced Beginner
    Windows 7 32bit Access 2007
    Join Date
    Jun 2015
    Location
    Canada
    Posts
    33

    Day of the week + the date to display in a table date field MSAccess 2007


    How can I display the day of the week in a table date field alongside the date as: Wednesday, April 13, 2015 ? This feature existed in Access 2003 and after importing this table into Access 2007 last summer, it continued to display in the same format. However, with one of the numerous Office updates I received through Windows update since November, this feature was eliminated, and I don't know how to restore it - I really need to see the day of the week. Can someone please help?

  2. #2
    Ajax is online now VIP
    Windows 8 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    9,148
    How was it formatted in 2003 and now?

  3. #3
    ineuw's Avatar
    ineuw is offline Advanced Beginner
    Windows 7 32bit Access 2007
    Join Date
    Jun 2015
    Location
    Canada
    Posts
    33
    It was set to "Long date" from the dropdown list.

  4. #4
    Ajax is online now VIP
    Windows 8 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    9,148
    this works for me

    dddd", "mmmm dd", "yyyy

    and returns for example

    Wednesday, January 28, 2015

  5. #5
    Ajax is online now VIP
    Windows 8 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    9,148
    Long Date would never produce the result you say you had in 2003, so I suspect it is not an update is the issue, but someone has changed the format

  6. #6
    ineuw's Avatar
    ineuw is offline Advanced Beginner
    Windows 7 32bit Access 2007
    Join Date
    Jun 2015
    Location
    Canada
    Posts
    33
    Thanks Ajax. Yes, it works. It's interesting that MS changed the "Long date" format, since I see it on the web that it did exist in 2008, which means MS Access 2007 had it.
    PS. Who could have changed,??? I just remembered how and where it changed. (Windows Regional settings) I'll get back to you. Thanks again.
    PPS. Yes it was set wrong. Now it's OK and apologize for the trouble.

  7. #7
    orange's Avatar
    orange is offline Moderator
    Windows 8 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    15,619
    ineuw,


    Try
    format(Date,"dddd, mmmm dd, yyyy")
    Saturday, January 23, 2016

  8. #8
    Ajax is online now VIP
    Windows 8 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    9,148
    Just done a deeper dive and found this

    http://www.techonthenet.com/access/f...ate/format.php

    note
    Long Date Displays date based on your system's long date setting


    So perhaps your system settings for Long Date have changed

  9. #9
    ineuw's Avatar
    ineuw is offline Advanced Beginner
    Windows 7 32bit Access 2007
    Join Date
    Jun 2015
    Location
    Canada
    Posts
    33
    Previously, in XP setting the "Long date" format was simpler - one had only a single choice. Now, the "Long date" format has two settings - with, or without the day of the week. Selected the wrong one when I set up Windows 7. Also, while I was a Access VBA programmer for years, after retiring a few years ago, I rarely use it - but still enjoy it when I do. And, just proved it now that "if you don't use it, you loose it."

  10. #10
    orange's Avatar
    orange is offline Moderator
    Windows 8 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    15,619

  11. #11
    ineuw's Avatar
    ineuw is offline Advanced Beginner
    Windows 7 32bit Access 2007
    Join Date
    Jun 2015
    Location
    Canada
    Posts
    33
    Not too far from Ottawa, but far from West Palm Beach. . . . Montreal. :-)

Please reply to this thread with any new information or opinions.

Similar Threads

  1. MSAccess 2007/2010 Date Picker Replacement - Version 3
    By pkstormy in forum Code Repository
    Replies: 8
    Last Post: 10-06-2015, 05:39 AM
  2. Replies: 9
    Last Post: 06-19-2015, 03:37 PM
  3. Replies: 3
    Last Post: 01-21-2015, 02:40 PM
  4. Replies: 20
    Last Post: 01-13-2015, 02:23 PM
  5. Replies: 3
    Last Post: 04-01-2012, 01:40 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums - Senior Forums