0

Greater than or equal to a specific date

Jet Reports Historic Posts

February 02, 2011 14:31

None

Follow

Hi,

I am trying to select data based on a date or greater than the date. My formula is listed below. I am using JR version 7.

NL("Sum","MyTable","MyField","Filter1",$C$2,"Filter2",>=$D10)

Cell $D10 contains a date such as 1/24/2011.

However, this returns an Excel error.

Please advise where I went wrong.

Thanks,

Haresh

• Facebook
• Twitter
• LinkedIn

5 comments

• 
  Jet Reports Historic Posts February 02, 2011 15:38 Official comment

  Jet Reports has a very user friendly function that transfers a date and apply a filter for a range at the same time: NP("Datefilter").
  
  In your example you could do:
  Cell D11 =NP("Datefilter",$D10)
  Cell ??? NL("Sum","MyTable","MyField","Filter1",$C$2,"Filter2",$D11)
  
  Or all in one go:
  Cell ??? NL("Sum","MyTable","MyField","Filter1",$C$2,"Filter2",NP("Datefilter",$D10))
  
  Does that work for you?

• 0
  
  Jet Reports Historic Posts February 02, 2011 16:05

  Hans,
  Thanks for your reply. I am aware of this function; however, I did not think to use it. It might do the trick. I will try it and update you.
  Thanks again,
  Haresh

• 0
  
  Jet Reports Historic Posts February 02, 2011 16:46

  Hans, That works for me.
  Thanks for the tip.
  Haresh

• 0
  
  Jet Reports Historic Posts February 15, 2011 22:50

  Hi Hans,
  
  How do we create a date range for the universal connector to an SQl database?
  
  startdate..enddate is NAV specific?
  
  tried using >=startdate&<=enddate but no luck there

• 0
  
  Jet Reports Historic Posts February 21, 2011 19:08

  Hi,
  
  No startdate..enddate is not NAV specific. It should work for universal connectors as well. You can just use the NP(DateFilter) function to create one of these filters as described by Hans. Is it not working for you?
  
  Regards,
  Hughes