I am getting a syntax error with this formula and can’t quite figure it out.
=IIF ((DateDiff(interval, [ARInvoice.DueDate], Today()) >=30 and (DateDiff(interval, [ARInvoice.DueDate], Today())<60, [ARInvoice.CuryDocBal],0)
I am trying to create columns of data depending on the “aging” of the invoice balance in a GI so that we can export to Excel for submission to our Auditors. The value should either be zero or the invoice balance.
I have this similar formula that works fine for current invoices:
=IIF ([ARInvoice.DueDate] >= Today(),[ARInvoice.CuryDocBal],0)
Best answer by palboresView original