mibuso.com

Microsoft Business Solutions online community
It is currently Sat May 25, 2013 5:12 am

All times are UTC + 1 hour [ DST ]




Post new topic Reply to topic  [ 2 posts ] 
Author Message
 Post subject: Exclude Closing dates in DATEFILTER
PostPosted: Wed Jun 13, 2012 6:27 am 
Offline

Joined: Thu Jul 14, 2005 9:04 am
Posts: 86
Location: Malaysia
Country: Malaysia (my)
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?


Top
 Profile  
 
 Post subject: Re: Exclude Closing dates in DATEFILTER
PostPosted: Wed Jun 13, 2012 7:07 am 
Offline

Joined: Wed Apr 07, 2004 9:39 am
Posts: 339
Location: Bangalore
Country: India (in)
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


Top
 Profile E-mail WWW  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 2 posts ] 

All times are UTC + 1 hour [ DST ]


Who is online

Users browsing this forum: No registered users and 4 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum


Search for:
Jump to: