Results 1 to 3 of 3
  1. #1
    Romuba is offline Novice
    Windows 7 64bit Access 2013
    Join Date
    Mar 2015
    Posts
    2

    Date Displaying Incorrectly - numbers added.

    I have recently started learning to use Access and all is going very well except for the date. As can be seen from the images below I have set up my date function correctly in Control Panel and everywhere I use a date it is displayed correctly. In Access however numbers are added which I cannot figure where they are coming from and don't want them there. In the second image you can see what the various Format options look like. When long format is used in a Form or Report it displays those additional figure. I cannot get 2015 to display but get 15316 or similar instead.

    Please assist if you know this issue and solution.



    Click image for larger version. 

Name:	System Date.jpg 
Views:	7 
Size:	58.5 KB 
ID:	20154Click image for larger version. 

Name:	Access Date.jpg 
Views:	7 
Size:	33.5 KB 
ID:	20155

  2. #2
    orange's Avatar
    orange is offline Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,870
    I don't know your specific issue, and have not seen it before. But here is a link with info re dates that might be helpful to you. You may have some degree of corruption???

    Good luck.

  3. #3
    Romuba is offline Novice
    Windows 7 64bit Access 2013
    Join Date
    Mar 2015
    Posts
    2
    Thank you but I understand the various formatting options but I have info displaying that makes no sense.

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

Similar Threads

  1. Sum on Quantity added since last date?
    By mrmims in forum Queries
    Replies: 1
    Last Post: 10-29-2014, 09:30 PM
  2. Displaying phone numbers
    By MaineLady in forum Access
    Replies: 2
    Last Post: 10-19-2014, 03:27 PM
  3. Sort records by date added
    By gmaster in forum Programming
    Replies: 8
    Last Post: 06-12-2014, 01:21 AM
  4. Adding the Date & Time record added
    By jo15765 in forum Access
    Replies: 2
    Last Post: 11-26-2010, 11:31 PM
  5. Replies: 4
    Last Post: 01-29-2009, 02:43 AM

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