Creating a simple filter

[Kipster1203]

I have never put a filter in a report before so bear with me...

I need the report to a show a document if:



1. today's date - document issue date >= 14 days

2. Approval CHECK BOX is unchecked

No idea what to type in in the filter text box... help help help!

[pbaldy]

Depending on how you want to do it, you could use this technique as you open the report:

BaldyWeb wherecondition

or base the report on a query that contained those criteria. If you want to type something into the filter textbox, we can figure that out too. It's not the way I would go because it relies on the user to know how/what to type in.

[Kipster1203]

I gotta do it that way... Here is what I have typed in there right now

Now() - [Revision_Actual_Date] >= 14

This will show documents that a revision date older than or equal to 2 weeks, but I need a second filter because in addition to that, the check box called Customer_Approved must be UNCHECKED.

What should I type in for that? Thanks!

[pbaldy]

Now() - [Revision_Actual_Date] >= 14 AND Customer_Approved = False

or

Now() - [Revision_Actual_Date] >= 14 AND Customer_Approved <> True