0

Date filter

Jet Reports Historic Posts

March 15, 2012 14:19

None

Follow

Hi.

I am trying to replicate and group some date filters.
Based on input from viewer (options sheet):
Period: 01-01-2012..31-12-2012
Grouping No. of weeks: 3

Giving datefilters:
02-01-2012..22-01-2012
23-01-2012..12-02-2012
etc.

Grouping 4 weeks would be:
02-01-2012..29-01-2012
30-01-2012..26-02-2012
etc.

Is that possible ?

Br. mdp12

• Facebook
• Twitter
• LinkedIn

1 comment

• 0
  
  Jet Reports Historic Posts March 19, 2012 12:34

  You can try working something out with the Date table:
  
  D4 = NL("Rows","Date",,"Period Type","Week","Period Start",InputFromUser) E4 = NF(D4,"Period Start") F4 = NF(D4,"Period End") G4 = NP("DateFilter",E4,F4)