I am trying to apply a filter on a report, and keep getting a value error
My report returns a field called Due Date against an Opportunity. I would like to apply a filter that only returns entries that have a due date that is equal to or less than todays date plus five working days. To obtain that latter I have added a formula in cell B5 of =WORKDAY(TODAY(),5) to calculate today plus 5, and returns a value of 11th Dec. When I then try to apply a filter against the Due Date of <=$B$5 it gives me a value error, and I don't know why?
Can anyone help me resolve
Thanks
Jon
Date
Votes
2 comments
-
Jet Reports Historic Posts I would recommend using the .. to get an open ended range rather than doing a greater than/less than for a date.
For example, if I wanted to get all records before (and including) December 11th, my date filter would be ..12/11/15
You can use the NP("DateFilter") to create this easily by entering in an end date but no start date. View this KB article to reviewing using the NP function: http://kb.jetreports.com/article/AA-00487
It would also be helpful to know what Debug says when you evaluate the #VALUE because that may tell you what the real problems is which may be something different than what you think it is. -
Jet Reports Historic Posts Cheers, will give it a try
Please sign in to leave a comment.