DateDiff -1 problem

[John T.]

I have two date fields:

InitialDate
InspDate

I've tried to use a Datediff expression within an IIF function (see below)
in an unbound textbox to give me the amount of days elapsed between
InitialDate and current date:
- after 6 days have elapsed from the InitialDate and
- only if the InspDate field is empty.

But, if the InspDate field is populated, then there would be a blank field
in the unbound text box.
The expression that I tried to use is:

=IIf(IsNull([InspDate]),DateDiff("d",[InitialDate],Date())>6,"")

The result is that it does recognize the 6 days elapsed but it expresses it
as -1.
It does not give me the actual number of days elapsed.
And if the days elapsed is within 6 days difference, it produces a result of
zero.
please help.

[Peter]

=IIf(IsNull([InspDate]) and DateDiff("d",[InitialDate],Date())>6,
DateDiff("d",[InitialDate],Date()),"")

Pete
"John T." <g4****@hotmail .com> wrote in message
news:42******** *************** @news.optusnet. com.au...

I have two date fields:

InitialDate
InspDate

I've tried to use a Datediff expression within an IIF function (see below)
in an unbound textbox to give me the amount of days elapsed between
InitialDate and current date:
- after 6 days have elapsed from the InitialDate and
- only if the InspDate field is empty.

But, if the InspDate field is populated, then there would be a blank field
in the unbound text box.
The expression that I tried to use is:

=IIf(IsNull([InspDate]),DateDiff("d",[InitialDate],Date())>6,"")

The result is that it does recognize the 6 days elapsed but it expresses
it
as -1.
It does not give me the actual number of days elapsed.
And if the days elapsed is within 6 days difference, it produces a result
of
zero.
please help.