0

Date Checking Problem

Jet Reports Historic Posts

August 08, 2016 13:00

None

Follow

Try this in cell B2:

=NP("EVAL","=Today()")

• Facebook
• Twitter
• LinkedIn

2 comments

• 
  Jet Reports Historic Posts August 08, 2016 14:15 Official comment

  Not sure if it's a typo on posting, but it's NP("Eval") not NL("Eval")
  
  And try this as your formula:
  
  =nl("Rows","Vendor Ledger Entry",,"Original Pmt. Disc. Possible","<>0","Remaining Amt. ($)","<0","Pmt. Discount Date", NP("DateFilter",$B$2,))

• 0
  
  Jet Reports Historic Posts August 08, 2016 13:00

  I know I am missing the obvious, but I cannot get this simple formula to work. I have trying to check our accounts payable to see if there are any prompt payment discounts available. When I try to add a "date check" at the end of the formula I get an error message.
  
  Cell: $B$2 is set to =nl("EVAL","Today()")
  
  =nl("Rows","Vendor Ledger Entry",,"Original Pmt. Disc. Possible","<>0","Remaining Amt. ($)","<0","Pmt. Discount Date",">$B$2")
  
  When I try $B$2 without the quotes I also get an error message. If I hard code the date in, "Pmt. Discount Date","08/08/16") the formula works correctly.
  
  Ideas?
  
  Thanks.