Exclude Closing dates in DATEFILTER

jordi79

Hi,
I am trying to exclude closing dates in a range of date filter. There seems to be no easy way to do this.

I cannot just filter like this -->
010111..311212|<>C*
NAV does not accept filters like that.

I have to loop the accounting period table and determine closing dates from there, and append the closing dates from accounting period table. Is there an easier way to do this?

Chinmoy

I don't think there is a way to do this when you are entering the dates in the filter box through an interface.. but when filtering through code you can use <> CLOSINGDATE(311209D), however this does not work with a range of dates.

Chn