Hi,
I'm trying to put together a flowfield that will calculate whether a customer has purchased in the last 6 months.
I have tried many variations of the below CalcFormula below but keep getting "CALCDATE... is not a valid date"
Exist("Cust. Ledger Entry" WHERE (Posting Date=FILTER(> CALCDATE(<-6M>) ),Document Type=FILTER(Invoice),Customer No.=FIELD(No.) ) )
Another one I'd like to do is this for the previous financial year:
Posting Date=FILTER(-CY-1Y..CY-1Y)