Hey all,
How do I set a Posting Date filter to not include the date range of my option?
=NL("Rows","Sales Header",,"Salesperson Code","@@"&$I10,"Posting Date",$C$5,"Status","Open")
I basically want to add a <> operator to the $C$5 filter in that formula but it doesn't seem to be working..
Date
Votes
3 comments
-
Jet Reports Historic Posts Official comment Tried both of those but it just kept giving me a VALUE error in the formula.
Ended up just doing a separate filter that minuses one day from the starting date range so if the range was 07/01/13..07/07/13 my other filter would be ..6/30/13. That works cause I was looking for all open orders outside of the date range specified. Thanks! -
Jet Reports Historic Posts "<>"&$C$5 doesn't work?
Cheers
André -
Jet Reports Historic Posts Hi
Could this be an option for u..
put the <> in ure option value
so if C5 was "01-01-2013..30-06-2013" before, it should be "<>01-01-2013..30-06-2013"
Best regards
Søren
Please sign in to leave a comment.