0

Date Filter

Jet Reports Historic Posts

June 29, 2009 09:37

None

Follow

Hi @ all,

I need a date filter like "Date";"01.01.2009.. TODAY", always the actual date of the day the report is being refreshed.

Any ideas?

Thanks,

Oliver

• Facebook
• Twitter
• LinkedIn

5 comments

• 
  Jet Reports Historic Posts June 29, 2009 14:10 Official comment

  Using the formula & cell locations in my example, your formula would look like this
  
  B2 =np("Eval","now()")
  B3 =np("Datefilter","01/01/09",B2)
  =NL("Summe";"Projektposten";"Menge";"Projektnr.";"9000-C09";"Buchungsdatum";B3;"Nr.";C8)
  
  Presuming Buchungsdatum is some sort of date field.

• 0
  
  Jet Reports Historic Posts June 29, 2009 13:06

  Welcome to the Jet community.
  
  This is how I do my date filters:
  B2 =np("Eval","now()")
  B3 =np("Datefilter","01/01/09",B2)
  
  I think the NL function works here too. I can never remember which one is the preferred method.
  
  cheers

• 0
  
  Jet Reports Historic Posts June 29, 2009 13:44

  Thanks a lot, the first one is working.
  
  But the second one is not so easy, I want to filter within this function, from 01.06.2009 until today, and this is not working so far…
  
  =NL("Summe";"Projektposten";"Menge";"Projektnr.";"9000-C09";"Buchungsdatum";"01.06.2009..29.06.2009";"Nr.";C8)
  
  Any ideas?
  This would help me a lot…

• 0
  
  Jet Reports Historic Posts June 29, 2009 14:15

  you are the best, thanks a lot !!!!

• 0
  
  Jet Reports Historic Posts June 29, 2009 14:29

  No worries. Depending on how you are using your formulas, you might want to make the reference to B3 absolute, i.e. $B$3.
  
  cheers