Results 1 to 2 of 2

Thread: Date Format

  1. #1
    Join Date
    Jun 2004
    Posts
    14

    Unanswered: Date Format

    Hi!

    Using Access 2000 I have changed default Date format to dd/mm/yyyy
    and set Input Mask to 00/00/0000;;_.

    Regional setting is mm/dd/yy.

    I want to set date to my deifned format. But it shows the system regional setting format.

    So when I enter date value 07/12/2004 in the form to serach the respective record. It takes 12/07/04 and shows no record found.

    I want to do this without changing the regional setting of any OS.

    Help needed asap.

    Subho

  2. #2
    Join Date
    Jul 2004
    Posts
    8

    Smile

    Hi Subho

    Try Tools- Options - General and tick "use 4 digit date format"

    Hope this helps

    Richard

Posting Permissions

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