0

How do you set a date duration when pulling out a list of items and how do you limit the list that Jet Report pulls out?

Josh

April 30, 2021 09:47

None

Follow

Hi,

I'm trying to pull out a list of entries within a certain date, say 1st Feb 2020 to 1st April 2020. May I know what is the formula for this if I'm using NF?

 

Also how can I limit the amount of entries from this list that is pull out?

• Facebook
• Twitter
• LinkedIn

1 comment

• 0
  
  Marc May 06, 2021 10:06

  To use NF, I assume you're linking it to a key/cache created by an NL function.

  You would add all filters (including date range) into the NL function and this would allow NF to extract only the dates you wanted.

  The NL code would look something like:

  =NL("Rows",[table name],,"Posting Date" [or other date in the table],NP("DateFilter","01/02/2020","01/04/2020"),[other filters])