Has anyone build a Jet report that exclude weekend in a selected date range?
Eg. Selected date range: 03/09/2009..08/09/2009
I want to exclude 05/09 & 06/09/2009 since they fall on Sat. & Sun.
Date
Votes
6 comments
-
Jet Reports Historic Posts I think you would have to build two filters (one for each range each side of the weekend) and then union then together.
-
Jet Reports Historic Posts I Agree with Markl,
It is a Navsion limitation that stops multiple date ranges being used in the same filter. Was very frustrated by this a couple of months ago as would have saved a lot of design in a time series analysis I was creating :(
Regards
Dean -
Jet Reports Historic Posts Hi Markl,
Thanks for your response, but don't quite understand what you mean. Can you give more concrete example?
If the selected date range is large, example, 1 Jan 09 to 31 Aug 09, will this pose a problem based on your proposed filter? -
Jet Reports Historic Posts =NL("Filter";"Date";"Period Start";"Period Type";"Date";"Period No.";"1..5";"Period Start";"03-09-2009..08-09-2009")
For "Period Type" = Date, "Period No." 1 to 7 equals Monday till Sunday so one makes a filter for "Period Type" = Date, "Period No." = "1..5" gives you all the correct days…
[size=200]AM I GOOD OR WHAT ;)[/size] [size=50]Sorry sometimes you need to pat yourself on the shoulder.[/size]
One BIG warning, dont use an open date filter on the NL("Filter") function, like "..31-12-2008" or "01-01-2009..", because the Date table is a Virtual Table it will generate a filter starting 03-01-0001 till 31-12-2008 or 01-01-2009 till 31-12-9999 excluding the weekends… -
Jet Reports Historic Posts Nice work Sebastiaan!
-
Jet Reports Historic Posts Sebastiaan,
I have tested your NL formula and it worked! Thanks for your help & you're great!
Please sign in to leave a comment.