DateDiff

B

bdehning

I now need to know how to proceed if I have another field called
[VerbalDate]. See question below which I got to work.

But I need to do using either Rpt Date or Verbal Date. The over 10 will not
count if VerbalDate or Rpt Date is within 10 Days. Do I still use DateDIff
somehow?

Help Please.

Brian


In the query behind the form, create a calculated field like this...
Over10 : IIF(DateDiff("d",[Call Date],[Rpt Date])>10,1,0)
Then sum Over10 in any footer.
hth
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions

bdehning said:
I have a report with the following: =DateDiff("d",[Call Date],[Rpt Date])
which shows me the number of days between the two dates located in Text
Box
with name text29 for many records.

If in this report I now want to count the number of times that this
difference is more than 10 days in a footer is it possible and how do I
do
it.???
 
O

Ofer

Try this

Over10New: IIF(DateDiff("d",[Call Date],[VerbalDate])>10 Or
DateDiff("d",[Call Date],[Rpt Date])>10,1,0)

--
I hope that helped
Good luck


bdehning said:
I now need to know how to proceed if I have another field called
[VerbalDate]. See question below which I got to work.

But I need to do using either Rpt Date or Verbal Date. The over 10 will not
count if VerbalDate or Rpt Date is within 10 Days. Do I still use DateDIff
somehow?

Help Please.

Brian


In the query behind the form, create a calculated field like this...
Over10 : IIF(DateDiff("d",[Call Date],[Rpt Date])>10,1,0)
Then sum Over10 in any footer.
hth
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions

bdehning said:
I have a report with the following: =DateDiff("d",[Call Date],[Rpt Date])
which shows me the number of days between the two dates located in Text
Box
with name text29 for many records.

If in this report I now want to count the number of times that this
difference is more than 10 days in a footer is it possible and how do I
do
it.???
 

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

Top