Sign Up for Training |
Jet Global Company Site
Community
Downloads
Submit a Request
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.

Example

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

Comments