IIf expression

D

Don

I am trying to return a statement of "Expired" if the difference in date days
is greater than 30 days if not, then return the number of days between the
dates. However, I am not sucessful. Please look at my expression and see
where I am going wrong.

IIf(DateDiff("d",[CommitteeDate],Now()>30),"Expired",
(DateDiff("d",[CommitteeDate],Now())))
 

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

IIf expression 2
Countdown macro - display settings 2
Subtracting two cell dates and highlight if over due by a certain amount of days 0
How to use/create code in MS Word to calculate age? 0
Conditional formatting with dates 7
DateDiff and Count/Sum 6
Iif Query 5
Avoiding Leads, using SVT, and Linking Tasks correctly 0

Top