0

Filter

Jet Reports Historic Posts

November 28, 2008 11:59

None

Follow

How can I make a filter like this

is empty or > date

this one didn't work

Cell D2 is date

=NL("Rijen";"Project;;"Ending Date";"''|>"D2)

• Facebook
• Twitter
• LinkedIn

3 comments

• 0
  
  Jet Reports Historic Posts November 28, 2008 13:17

  Hi Norbertus,
  
  Does Cell D2 contain a date value? Or is it already converted into a text? What error message do you get?
  
  In Excel a date is just a number - presented in a date format. And NAV doesn't understand the Excel value. So we must convert the date into a text.
  
  If you change your formula into:
  =NL("Rijen";"Project;;"Ending Date";"''|"&NP("Datumfilter";D2+1))
  (sorry folks for using the Dutch format here. Norbertus is Dutch and I wanted to make it easy for him to copy/paste the formula)
  
  Please let us know if this works. Fijn weekend!

• 0
  
  Jet Reports Historic Posts November 28, 2008 13:34

  Hello Hans,
  
  Thanks it works.
  
  Have I nice weekend.
  ( i missed you at the Qurius Customer Day)
  
  Groeten, Norbertus

• 0
  
  Jet Reports Historic Posts December 03, 2008 15:09

  Hi guys,
  
  Thanks for this, I was looking for something like this. For those working in English
  
  =NL("Rows","Project",,"Ending Date","''|"&NP("DateFilter",D2+1))