0

Select multiple date fields as an option

Jet Reports Historic Posts

June 06, 2016 20:39

None

Follow

I want to select multiple date fields as an option. I am currently using as my date filter the following:
"Posting Date","070114..053115|070115..053116"

If I put date 1 in $B$2 and date 2 in $B$3, how do I show this as the field filter?

• Facebook
• Twitter
• LinkedIn

1 comment

• 0
  
  Jet Reports Historic Posts June 07, 2016 06:58

  There are 4 dates in your filter, and you're only giving me two of them! But I'm making the assumption that you are giving me one and two, and that three and four are the same date but a year later.
  
  So the first thing I would do is calculate the other two dates (a year later than the first two) using:
  $B$4: =EDATE($B$2,12)
  $B$5: =EDATE($B$3,12)
  
  Then you build your filter:
  
  $B$6 =NP("DateFilter",$B$2,$B$3)&"|"&NP("DateFilter",$B$4,$B$5)