Results 1 to 2 of 2
  1. 01-29-2021, 12:35 PM #1
    Benj
    Benj is offline Advanced Beginner
    Windows 7 32bit Access 2016
    Join Date
    May 2018
    Posts
    33

    change date format

    Good day! I transferred my access file to a new computer. in the old computer, i would enter 29/1 for January 29, 2021, but in the new computer i would not accept since 29 would be its month and 1 its date. Am used to entering the date that way. TIA!
    Reply With Quote Reply With Quote
  2. 01-29-2021, 12:38 PM #2
    Welshgasman
    Welshgasman is offline VIP
    Windows 10 Access 2007
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    6,555
    Have you set your region settings correctly?
    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
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Similar Threads

  1. How to change date format inside a text field?
    By johnrohan in forum Access
    Replies: 3
    Last Post: 08-21-2017, 12:59 PM
  2. Format date change and export in Office 2016?
    By NISMOJim in forum Reports
    Replies: 2
    Last Post: 02-21-2017, 04:21 PM
  3. field format change date to text
    By Jen0dorf in forum Access
    Replies: 1
    Last Post: 09-02-2016, 12:57 PM
  4. How to Change Date Format
    By bulbul4u in forum Queries
    Replies: 1
    Last Post: 04-01-2011, 03:02 PM
  5. Can i change the format of DATE () ?
    By Nokia N93 in forum Access
    Replies: 2
    Last Post: 11-27-2010, 01:34 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
  •  

Forum Rules

Other Forums: Microsoft Office Forums