Sign Up for Training |
insightsoftware Company Site
Submit a Request
Become a Jet Insider
Give Feedback

Excluding Closing Dates

Help Topics...

Sometimes you may want to exclude closing dates from your query when you are using date filters. This can be accomplished by putting <>C& in front of your date filter.
This information is only relevant to Dynamics NAV users.


This example uses a Cronus USA database, which has closing dates of 12/31/17, 12/31/18, and 12/31/19:

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

This will, in effect, create a filter as "01/01/17..12/31/19&<>C12/31/17&<>C12/31/18&<>C12/31/19"

Was this article helpful?
0 out of 0 found this helpful