Results 1 to 4 of 4
  1. #1
    mugsyronrox is offline Novice
    Windows 10 Access 2016
    Join Date
    Sep 2020
    Posts
    2

    Help using iif and date add statement

    I'm trying to write and expression that adds 14 days to the date received date and returns the result in the date due column if the column labeled "letter requiring response" is "yes". Shown below are the fields in my database. I'm terrible at writing iif statements so any help would be appreciated.




  2. #2
    mugsyronrox is offline Novice
    Windows 10 Access 2016
    Join Date
    Sep 2020
    Posts
    2
    The field names are:

    DateRceived

    LetterRequiringResponse This is a YES/NO field

    DateDe

  3. #3
    ssanfu is offline Master of Nothing
    Windows 7 32bit Access 2010 32bit
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    For a query or VBA?


    "DateDe" should be "DateDue"?

  4. #4
    CJ_London is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,397
    assuming this is a query or form- (don't store calculated values in tables)

    datedue:iif(LetterRequiringResponse,datereceived+14)

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

Similar Threads

  1. If statement with a date
    By UT227 in forum Programming
    Replies: 2
    Last Post: 02-01-2020, 09:24 PM
  2. Date Driven If statement in VBA
    By OverPlayed in forum Modules
    Replies: 4
    Last Post: 03-01-2018, 03:03 PM
  3. IIF statement in Date calculations
    By wnicole in forum Access
    Replies: 1
    Last Post: 09-18-2013, 02:26 PM
  4. IIF statement using a date
    By elegant in forum Queries
    Replies: 1
    Last Post: 05-26-2011, 11:00 AM
  5. ISO8601 Date in a IIF Statement
    By monkeyman in forum Queries
    Replies: 2
    Last Post: 05-23-2011, 12:16 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