Results 1 to 6 of 6

Thread: Today's date

  1. #1
    Lounger
    Join Date
    Jan 2001
    Location
    Hastings, Nebraska, USA
    Posts
    41
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Today's date

    If Access is so smart, why won't the CTRL-; quick key work for inputting today's date in a form? It only works when the date has 2 digits in the month and in the day, otherwise the numbers get stuffed in the wrong slot, and you get NO date! Excuse me if this has already been covered.... Russ

  2. #2
    4 Star Lounger
    Join Date
    Dec 2000
    Location
    London, Ontario, Canada
    Posts
    437
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Today's date

    Hello Russ:
    Actually, I believe the Access Shortcut Key Ctrl; inserts the date in the format designated in Regional Settings Short Date. Any date field in Access will convert it to its default, but -- if you have an input mask that conflicts with the the Regional Setting, you will have a problem. There are a number of ways to programatically solve the problem, for example where today's date is the common entry to a field, you could set it as the default for that field.

  3. #3
    4 Star Lounger
    Join Date
    Jan 2001
    Location
    Altnau, Thurgau, Switzerland
    Posts
    447
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Today's date

    How about a button next to the field called Today (surprise surprise). OnClick and you insert todays date into the field. Quick and self-explanatory.

  4. #4
    Lounger
    Join Date
    Jan 2001
    Location
    Hastings, Nebraska, USA
    Posts
    41
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Today's date

    Good answer! That seems to work better than the quick key. Thanks.

  5. #5
    Lounger
    Join Date
    Jan 2001
    Location
    Hastings, Nebraska, USA
    Posts
    41
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Today's date

    Thanks for the info about Regional settings. Sometimes I forget to look elsewhere for the answer! That helps.

  6. #6
    Star Lounger
    Join Date
    Feb 2001
    Location
    South Carolina, USA
    Posts
    66
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Today's date

    You could put the =date() as a default value for the date field. The current date will always appear and if you need to change it, just type over it.

    Deborah

Posting Permissions

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