0

NP EVAL Help

Jet Reports Historic Posts

April 28, 2010 21:02

None

Follow

Here is the function I've created to generate two date values (Current Year YTD) joined by '..' to generate a date range for NAV. The output looks like this: 1/01/2010..29/04/2010

=TEXT(DATE(YEAR(NOW()),1,1),"d/mm/yyy")&".."&TEXT(DATE(YEAR(NOW()),MONTH(NOW()),DAY(NOW())),"d/mm/yyy")

This works…however, my understanding is that if I'm using the Jet Scheduler the NP("Eval",) function must be added. First question, am I right in my assumption that NP("Eval",) needs to added? Second, I'm trying to add it but it's kicking my butt. Anyone out there that could assist in getting this NP statement integrated?

Many thanks in advance!

• Facebook
• Twitter
• LinkedIn

1 comment

• 
  Jet Reports Historic Posts April 28, 2010 22:38 Official comment

  Hi Blair,
  
  The only thing you actually need to use the NP(Eval) function for is the Now() function. You would do it like this:
  
  =NP("Eval","=NOW()")
  
  Then you can reference the cell with that formula in it in your range formula. I might also add that you can create a date range by using NP(DateFilter) like this:
  
  =NP("DateFilter",DATE(YEAR($C$3),1,1),DATE(YEAR($C$3),MONTH($C$3),DAY($C$3)))
  
  Does this help?
  
  Regards,
  Hughes