Conditional Formatting in Forms

J

Judy

I'm trying to get a form to display a "Yes" or "No" depending on a review of
two dates. Tried a number of times. In English, want it to do the following
- if the Date returned to marketing is less than or equal to the due date,
write "Yes" and if not write "No" - otherwise leave blank.
 
N

NuBie via AccessMonster.com

ans = iif(dateReturned <= dueDate,"Yes", "No")
write "Yes" and if not write "No" - otherwise leave blank.
Click to expand...

What instances you want to leave it blank, since date returned equal or less
than due date is a "YES", date returned greater than due date is a "NO".
Where does the "otherwise leave blank" fits in?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Use TODAY() function as the criteria in a SUMIF formula 1
Avoiding Leads, using SVT, and Linking Tasks correctly 0
Cobditional Formatting Rows based on dates in action plan. 0
Excel Logical function 5
Conditional Formatting to Another Cell 0
Conditional formula's in excel-calculating with dates / age andaffiliation date calculus 3
conditional formatting stops responding after 6th record on form 0
Mail Merge - displaying a conditional number of decimals 5

Top