Skip to main content
insightsoftware Docs insightsoftware Docs
{%article.title%}
Published:
Was this article helpful?
0 out of 0 found this helpful

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"

Published:

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"

For an optimal Community experience, Please view on Desktop