Days Past Due Report

[meierswa]

I am trying to create a report that will list all documents that have been received but have not been processed with 15 days.

Right now I have 2 dates (dtReceived and dtCompleted, Is Null) in the SQL statement in the report.

I also have a form with a text box (txtDate). The date input on the form should be compared to the dtReceived to see if 15 days have passed and the document has not been completed. I tried this:

DateDiff("d","dtReceived",[Forms]![frm15days]![txtDate])>15

Am I even close?

 

[KornGeek]

If I'm understanding you correctly, I think you need to change "dtReceived" to Me!dtReceived (without any quotes). I'm not positive, but I think this should get you working.

 

[cbogz]

In your SQL statement, try the following as criteria for dtReceived:

< DateAdd(&quot;d&quot;,-15,[Forms]![frm15days]![txtDate])

DateAdd takes 15 days off of the value you've entered into the form. If dtReceived is still less than that value, then over 15 days have passed.

 

[meierswa]

This is what I ended up with:

Expr 1: DateDiff(&quot;d&quot;,[tblActivity]![dtReceived],[Forms]![frm15days]![txtDate])

with >15 in the criteria.

It seems to be working.