Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2011

    Unanswered: iif statement with date

    I would like to know if there is a way to use the expression:

    =iif([Order Sent]=yes,date(),null) can work by keep the date as the original date the order was sent, and not keep populating current date as days go by.

    This expression is in a text box in a form. The Order Sent is a check box in that same form. They are both fields in the same table. The goal is to check the order sent box and auto populate what day it was sent, and when the product is received, to just uncheck the order sent box, and the date will go away.

    Thanks in advance

  2. #2
    Join Date
    Apr 2012
    In my opinion, it is difficult to understand what you really want to know. Do you mean that that expression is correctly working?

Posting Permissions

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