Results 1 to 2 of 2
  1. #1
    laythrom is offline Novice
    Windows 7 64bit Access 2016
    Join Date
    Feb 2017
    Posts
    3

    Date Calculation auto fill - date plus 'x' days

    I am pretty new when it comes to Access and I am in the process of creating several forms to populate a database. In the table, I have a field to enter the date and I have another field that needs to have a 'destruction date' listed. Basically, I want the 'destruction' field to take the date entered in the previous field, add 90 days to it and display the calculated date (example below).

    Date: 10FEB2017
    (plus 90 days)
    Destruction date would equal: 10MAY2017

    I attempted to enter the calculation =[Date Logged]+90 but I am greeted with a pop up window stating "You cannot set 'Destruction Date' to the Calculated data type."



    If anyone can help solve my problem, it would be much appreciated.

    Thanks for reading.

  2. #2
    Bulzie is offline VIP
    Windows 7 64bit Access 2007
    Join Date
    Nov 2015
    Posts
    1,474
    = DateAdd("d",90,[Date logged])

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

Similar Threads

  1. Replies: 3
    Last Post: 08-21-2015, 08:14 AM
  2. Auto Fill with Date and Time
    By Access_Novice123 in forum Access
    Replies: 6
    Last Post: 02-19-2015, 12:04 PM
  3. Auto Fill a date in a field
    By SJJ in forum Access
    Replies: 1
    Last Post: 02-17-2014, 02:39 PM
  4. Lock field after auto date fill
    By DCV0204 in forum Forms
    Replies: 4
    Last Post: 11-25-2013, 08:53 AM
  5. Auto fill a due date column in a query
    By Dexter in forum Queries
    Replies: 7
    Last Post: 02-23-2011, 07:00 AM

Tags for this Thread

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