Sign Up for Training |
Jet Express Support |
Jet Reports Company Site
Jet Reports Financials
Jet Professional
Jet Enterprise
Submit a Request
Give Feedback

Excluding Closing Dates

You can exclude closing dates from your query when you are using date filters by putting <>C& in front of your date filter, which will then no longer include the closing date. The example below is using a Cronus USA database, which has closing dates of 12/31/13, 12/31/14, and 12/31/15.

=NL ("Sum","G/L Entry","Amount","Posting Date","<>C&01/01/13..12/31/15","G/L Account No.",54701)

This will, in effect, create a filter as "01/01/13..12/31/15&<>C12/31/13&<>C12/31/14&<>C12/31/15"

This information is only relevant to Navision users.

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request