Sign Up for Training |
Jet Global Company Site
Submit a Request
Give Feedback

Excluding Closing Dates

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
Have more questions? Submit a request