0

NL Functions with OR

Jet Reports Historic Posts

June 21, 2010 17:22

None

Follow

In my data there are two fields, one is start date and the other is end date. My NL function needs to pick up data if the start date OR the end date is between the user input date range. Any ideas? I am using version 9.2

• Facebook
• Twitter
• LinkedIn

1 comment

• 0
  
  Jet Reports Historic Posts July 16, 2010 16:11

  I think you would need to use NP("Union") to do that. So it would go something like this:
  
  =NL("Rows",NP("Union",NL("Filter","Table","PrimaryKeyField","Start Date",$C$5),NL("Filter","Table","PrimaryKeyField","End Date",$C$5)))
  Does that help?
  
  Regards,
  Hughes