I'm using Allen Brown's
Method Two script to filter a report by date range. It's not quite working, and I haven't been able to see the problem. I'm using the script verbatum, except that I have set the values for my report name and date field, as instructed.
- If I enter one or both dates in the form and submit, I get an input box asking for the value of my date field; if I enter a date there, the report runs but comes up empty (even though there are known records for the range AND for the one date I entered in the query)
- If I leave both date parameters empty on the form, it runs beautifully, and the report contains all the records, as it should.
Any thoughts -- especially from anyone who is familiar with Allen Brown's solution -- would be most appreciated!