IIF formula to produce a date

[BlueHorizon]

Hi,

I appreciate any help with an IIF formula. I have a date in the [dtmOrdDate] field. I want to produce a report that displays today's date if today is [dtmOrdDate] plus 30 days. Otherwise, "" (blank). Here's what I've tried but it isn't working:

=IIf(Date()=[dtmOrdDate]+30,[dtmOrdDate],"")

Thanks in advance!

Best,
Blue Horizon/Kathy

Best,
Blue Horizon

 

[SkipVought]

Hi,

What does "it isn't working" actually mean, in particular?

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[dhookom]

IMO, I don't care for expressions that might return different data types. Your expression might return a date or a string. I would try.

=IIf(Date()=[dtmOrdDate]+30,[dtmOrdDate],NULL)

Duane
Hook'D on Access
MS Access MVP

 

[BlueHorizon]

Thanks, DHookam, NULL worked. I'm usually OK with "" to return a blank but not in this instance.

Good day!
Kathy

Best,
Blue Horizon