I have two list one is Archive data and one is the new stuff. I am filtering based on the Created>=DateAdd(Today(),-60,Days) as well as if data is not in the Invoice Processing Historical that matches DataCardValue53_5.Text then look in Invoice Processing.
I have tried this and it is not working I have the syntax wrong but cant figure out how to make it work
Filter('Invoice Processing Historic',Created>=DateAdd(Today(),-60,Days), (DataCardValue53_5.Text', NOT(DatacardValue53_5.Text in 'Invoice Processing' )))
Any help would be apprecaited.
Dorinda