Results 1 to 5 of 5
  1. #1
    George is offline Competent Performer
    Windows 7 64bit Access 2013 64bit
    Join Date
    Feb 2012
    Posts
    292

    Unexpected Date results


    Good day,

    The results in a report from the date range entered on a form on one computer differs vastly from the report results on another computer for the exact same entries. Can this be explained and corrected?

    This is the date range entered on the form: EmployeeName='Jamal Rogers' AND RequestDate Between #30/11/2022 8:27:46 pm# AND #01/12/2022 8:27:46 pm#

    On one computer the results are for the period stated here but on the other computer it outputs data from Jan 2022 to Nov 30
    Last edited by George; 12-01-2022 at 06:42 PM. Reason: Missing information

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,195
    It can be explained by Access interpreting the second date as Jan 12. More here:

    http://allenbrowne.com/ser-36.html
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #3
    George is offline Competent Performer
    Windows 7 64bit Access 2013 64bit
    Join Date
    Feb 2012
    Posts
    292
    Thanks for the link. It has provided useful information.

    However, my issue cannot be resolved there because I am in one location where the access dates have been working fine for years. However, now that I have just bought a new computer, directly from China, that computer is giving incorrect dates. So, I had to revert to the old computer. The problem seems to be with the settings in the new computer. Is there any setting that I can adjust here?

  4. #4
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    3,327
    Check your regional settings.
    Regardless, Access always uses the mm/dd/yyyy format for dates.
    Please use # icon on toolbar when posting code snippets.
    Cross Posting: https://www.excelguru.ca/content.php?184
    Debugging Access: https://www.youtube.com/results?sear...bug+access+vba

  5. #5
    xps35's Avatar
    xps35 is offline Competent Performer
    Windows 10 Office 365
    Join Date
    Jun 2022
    Location
    Schiedam, NL
    Posts
    124
    Check the date settings in Windows.
    Groeten,

    Peter

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

Similar Threads

  1. Unexpected sort results
    By George in forum Modules
    Replies: 17
    Last Post: 07-21-2016, 08:00 PM
  2. Replies: 6
    Last Post: 06-17-2015, 11:53 AM
  3. Unexpected results on Inner Join
    By Access_Novice in forum Access
    Replies: 2
    Last Post: 09-05-2014, 12:50 AM
  4. Unexpected results with DAO recordset
    By GraeagleBill in forum Programming
    Replies: 1
    Last Post: 10-07-2012, 07:37 PM
  5. Unexpected Results from Curdir?
    By bginhb in forum Programming
    Replies: 6
    Last Post: 08-17-2011, 03:58 PM

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