0

Date filter including blank and a date greater than ..

Jet Reports Historic Posts

December 15, 2013 22:40

None

Follow

Hi

I'm trying to retrieve data with the following properties:

- I'm trying to filter all records with a blank "to-date" using @@

- In addition I need to retrieve records with a date in "to-date" greater than today

I've been trying to do this: =NL("Rows";"Membership Service Line";;"To Date";">today()|@@")

Obviously I'm doing something wrong since it returns a #VALUE!

Any ideas?

/Mike

• Facebook
• Twitter
• LinkedIn

2 comments

• 
  Jet Reports Historic Posts December 16, 2013 15:54 Official comment

  Try this:
  
  =NL("Rows","Membership Service Line",,"To Date",NP("DateFilter",TODAY())&"|@@")

• 0
  
  Jet Reports Historic Posts December 18, 2013 22:05

  Hi
  
  It's working - thanks a lot!