Hi,
Can anyone advise why I'm not getting the correct value (returns zero) when I use the formula below which includes a cell reference for the document date:
=NL("Sum","Cust. Ledger Entry","Remaining Amount","Company=",$C$2,"Customer No.",$F13,"Document Date",">C11")
Yet if I use the below with a static date in the formula, it returns the correct value:
=NL("Sum","Cust. Ledger Entry","Remaining Amount","Company=",$C$2,"Customer No.",$F13,"Document Date","<05/05/2021")
Not sure if its an error in my formula or there is an alternative method.
Thanks in advance
M