Results 1 to 4 of 4
  1. #1
    manics31 is offline Novice
    Windows 10 Access 2016
    Join Date
    Sep 2016
    Location
    Philadelphia
    Posts
    23

    Automatic date question

    Hello all, I have a form that has a date field that I would like it to populate with a date. Right now on the default I have this
    Code:
    DateSerial(Year(Date()),Month(Date())+2,2)
    for two month, basically this field is to enter an expected date on completion. the question that I have is how do I make this field have an automatic date of 60 days from today's date?
    any help is appreciated.
    thank you all.

  2. #2
    JoeM is offline VIP
    Windows 7 32bit Access 2007
    Join Date
    Jun 2012
    Posts
    3,904
    Since Access stores dates as numbers which actually represent days (specifically, it is the number of days since 1/0/1900), just use:
    Code:
    Date() + 60

  3. #3
    manics31 is offline Novice
    Windows 10 Access 2016
    Join Date
    Sep 2016
    Location
    Philadelphia
    Posts
    23
    Thanks JoeM.
    Quote Originally Posted by JoeM View Post
    Since Access stores dates as numbers which actually represent days (specifically, it is the number of days since 1/0/1900), just use:
    Code:
    Date() + 60

  4. #4
    JoeM is offline VIP
    Windows 7 32bit Access 2007
    Join Date
    Jun 2012
    Posts
    3,904
    You are welcome.

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

Similar Threads

  1. Automatic Due Date Calculation?
    By mrjane in forum Access
    Replies: 4
    Last Post: 11-18-2015, 03:31 PM
  2. Automatic Date Entry
    By Al77 in forum Access
    Replies: 3
    Last Post: 02-27-2012, 12:06 PM
  3. Automatic date
    By vanstuurwiel in forum Access
    Replies: 5
    Last Post: 09-14-2010, 04:51 AM
  4. Follow up calls, put in automatic date
    By Loish in forum Access
    Replies: 1
    Last Post: 04-08-2010, 03:59 PM
  5. Automatic Date insertion
    By wbeau in forum Access
    Replies: 0
    Last Post: 03-10-2009, 12:51 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