I need to filter "Date Filter" to show records within a date range (Options!$D$7) and NOT blank (01/00/1900). I have tried to figure this out on my own and tried a couple of things I found here but it fails. Ideas?
this what I am trying to do;
=NL("Rows","Shipment",,"+Destination State-Country Code",Options!$D$5,"Date Filter",Options!$D$7&<>01/00/1900)
I am needing to show records that DO NOT include "Date Filter"value 01/00/1900 which I am told are actually blank?
HELP!?!
JET 7.1 (OLD I know)
thanks
K
Date
Votes
3 comments
-
Jet Reports Historic Posts Try putting brackets around the filter: "("&Options!$D$7")&<>0D"
-
Jet Reports Historic Posts thanks, but that did not work.
-
Jet Reports Historic Posts I think you need something like this for your filter:
Options!$D$7&"&<>1/00/1900"
1/00/1900 is actually 0 formatted as a date so filtering for <>1/0/1900 may not work on the database end. You may need to filter for <>0 instead like this:
Options!$D$7&"&<>0"
Regards,
Hughes
Please sign in to leave a comment.