0

Listing Records Based on Fields in Record

David C. Kjeldsen

October 21, 2020 15:07

None

Follow

I am trying to list the invoice numbers where the Order Date is greater than the Posting Date.

I have come up with this formula but I can't get it to work:

=NL("Rows","Sales Invoice Header","No.",NF(,"Order Date"),">NF(,""Posting Date"))

Ideas?

• Facebook
• Twitter
• LinkedIn

1 comment

• 0
  
  Bryan Robinson November 12, 2020 17:44

  Hi David

  Since you are comparing one field to another field on the same record, you do not need the NF for the Order Date.  Additionally, the syntax to compare to the NF is a bit odd

  =@NL("Rows","Sales Invoice Header","No.","Order Date","="">""&NF(,""Posting Date"")")