I am using this filter in a GV report:
and({Trx Type} = 1,{Job}<>100,or(and({Trx Date} >= {Start Date},{Trx Date} <= {As of Date}),and({Trx Date} >= {LY Start Date},{Trx Date} <= {LY As of Date})))
The filter evaluates okay but the problem is the {Job}<>100. It doesn't do anything to the View even though it's supposed to omit Job # 100.
_________________________
Miriam Wiebil
ChoiceTech Accounting Solutions