Excluding Closing Dates – Support Topics

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"

Updated May 16, 2019 15:34: Jet Reports Historic Posts

Example

Comments