I am working on a database that has two different date fields, one is the estimated date of departure, "Dept Date - Local" and the other is the actual Date of departure, "Dept Date Act Local". I would like to grab all "Aircraft ID" whose Dept Date - Local or Depart Date Act Local are within a specified range.
I know if I want to accept multiple values for one field, I could do something like
=NL("Rows","Trips","Aircraft ID","Trip Type Code","11|105")
But I need it for 2 fields, specifically I have tried the following:
=NL("ROWS","Aircraft",{"Owner Name","Aircraft ID","Tail Number","Model"},"+Tail Number","*","Aircraft ID",NL("Filter","Trip Legs","Aircraft ID","Dept Date Act Local",H$11,"Datasource=","fOS")&"|"&NL("Filter","Trip Legs","Aircraft ID","Depart Date - Local",H$11,"Datasource=","fOS"),"Datasource=","FOS")
Using the OR command on two NL("Filter") functions but that didn't work. I got a "FilterField is missing" error.
Date
Votes
1 comment
-
Jet Reports Historic Posts Hi,
You need to use NP(Union) to do this. So it might look something like this in your case:=NL("ROWS","Aircraft",{"Owner Name","Aircraft ID","Tail Number","Model"},"+Tail Number","*","Aircraft ID",NP("Union",NL("Filter","Trip Legs","Aircraft ID","Dept Date Act Local",H$11,"Datasource=","fOS"),NL("Filter","Trip Legs","Aircraft ID","Depart Date - Local",H$11,"Datasource=","fOS")),"Datasource=","FOS")
Does this work for you?
Regards,
Hughes
Please sign in to leave a comment.