0

date filter

Jet Reports Historic Posts

November 22, 2013 19:32

None

Follow

Regarding Jet Essentials 2013 and Nav Dynamics 2009 R2:

How do I set my Jet filter to run the equivalent of (today()+7..today()+35)?
That is to say, I want to schedule the report to run each Monday and gather the data from weeks 2 through 6.
If I just use today()+7, it works fine, but when I try to add the formula to set the stop date it errors out.

Thank you,
Chris

• Facebook
• Twitter
• LinkedIn

1 comment

• 0
  
  Jet Reports Historic Posts November 22, 2013 20:00

  Hi Chris,
  
  The easiest way is probably to use the NP(DateFilter) formula like this:
  
  =NP("DateFilter",today()+7,today()+35)
  Does that work for you?
  
  Regards,
  Hughes