Exclude Closing Dates for Date Filters

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"