I want to use filter on two fields of the same table with one value.
There are two columns named as posting date and document date and let's suppose I want to get rows having either posting date =TODAY OR document date =Today.
When I use SETFILTER two times it gives me rows having posting date and document date=TODAY.
BUT I want to get all rows whose posting date is TODAY may be document date is different and all rows whose Document date is TODAY may be posting date has different value.
I hope its enough to understand the scenario.
May be there is no possibilities to use OR with SETFILTER but if you Know another way to solve it then feel free to share with me I'll really appreciate that.
Thank you.
*This post is locked for comments
I have the same question (0)
