Results 1 to 2 of 2
  1. #1
    drklaasen is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    May 2015
    Posts
    1

    DateAdd expression

    Hello,
    I am an amateur when it comes to programming and I would appreciate some help with the following.
    I need to calculate the next date for screening from the last screening date using an interval.
    The fields are: LatestScreenDate, RecallFrequence (=integer) and NextMammoDueDate.
    I tried the expression: NextMammoDueDateateAdd("yyyy", [LatestScreenDate],[RecallFrequence]) but that gives an error about wrong parenthesis.
    I suspect that I am doing something laughable but I can't work it out.
    I am using MSAccess 2007.



    Thanks.
    I can't get rid of that smiley Read: D colon
    Last edited by drklaasen; 05-30-2015 at 06:26 AM. Reason: Smiley in the way

  2. #2
    Micron is offline Very Inert Person
    Windows 7 32bit Access 2007
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    13,421
    the useage is interval, amount, date. You have it the other way around.

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

Similar Threads

  1. DateAdd DateSerial
    By aellistechsupport in forum Queries
    Replies: 2
    Last Post: 04-30-2014, 05:09 PM
  2. the DateAdd
    By azhar2006 in forum Queries
    Replies: 1
    Last Post: 04-20-2014, 03:18 PM
  3. DateAdd Error
    By TimMoffy in forum Programming
    Replies: 2
    Last Post: 04-17-2013, 10:13 AM
  4. DateAdd()
    By cbrsix in forum Programming
    Replies: 3
    Last Post: 11-22-2011, 02:20 PM
  5. dateadd help
    By dubsdj in forum Queries
    Replies: 3
    Last Post: 03-03-2011, 07:22 PM

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