Report of Rental Dates where the field is blank.

[Odixay]

I want to build an expression from this =DateDiff("d",[Date Acquired],[Off Rent Date]) which will populate today's date where [Off Rent Date] is unpopulated. The off rent date is populated when these items are returned but not until they are sent, I would like this to give me a total number of days rented when I run the report. Any help is appreciated.

[RuralGuy]

Try:
=DateDiff("d",[Date Acquired],Nz([Off Rent Date],Date))

[Odixay]

When I enter your expression the dates which are populate with an Off Rent still total days, but now the unpopulated fields give an error.

[RuralGuy]

OK...try:
=DateDiff("d",[Date Acquired],IIF(IsNull([Off Rent Date]),Date(),[Off Rent Date]))

[Odixay]

Wow, that one works like a charm. I appreciate you help. Thanks alot!

[RuralGuy]

You are very welcome.