Results 1 to 4 of 4

Thread: Formula Error

  1. #1
    Join Date
    Jan 2004
    Posts
    106

    Unanswered: Formula Error

    Can somebody please tell me what is wrong with the following formula?

    Days Late: Iff([Date Returned]>[Date Due Back],DateDiff("d",[Date Due Back],[Date Returned]))

  2. #2
    Join Date
    Oct 2003
    Location
    Roanoke, Va
    Posts
    445

    Smile Re: Formula Error

    Originally posted by craig_dixon
    Can somebody please tell me what is wrong with the following formula?

    Days Late: Iff([Date Returned]>[Date Due Back],DateDiff("d",[Date Due Back],[Date Returned]))
    If I'm not mistaken, based on the placement of your parentheses, you've omitted what to do if the condition is false in the IIf statement.

    Gregg

  3. #3
    Join Date
    Jan 2004
    Posts
    492

    Re: Formula Error

    Originally posted by craig_dixon
    Can somebody please tell me what is wrong with the following formula?

    Days Late: Iff([Date Returned]>[Date Due Back],DateDiff("d",[Date Due Back],[Date Returned]))

    IIF not IFF

  4. #4
    Join Date
    Jan 2004
    Posts
    106
    thanks, just a stupid typin error

Posting Permissions

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