0

how to sort by date

Jet Reports Historic Posts

November 05, 2013 20:28

None

Follow

Hi there,

I have created the following two formula and would like to sort my data by date.

Cell E6 =NL("Rows","AccountTransactions",$F$2:$P$2,"TRX Date",Options!$D$10,"Account Number","@@"&$B6,"Posting Number","*")
Cell H6 = =NF($E6,"TRX Date")

how to sort data with NF function? Any help is greatly appreciated.

Thanks,
Louise

• Facebook
• Twitter
• LinkedIn

2 comments

• 
  Jet Reports Historic Posts November 05, 2013 21:25 Official comment

  Hi Louise,
  
  The NL(Rows) is the function which controls the replication of data, so the sort must occur there, not in the NF function. You just need to add a + or - in front of the TRX Date field for either an ascending or descending sort like this:
  
  =NL("Rows","AccountTransactions",$F$2:$P$2,"+TRX Date",Options!$D$10,"Account Number","@@"&$B6,"Posting Number","*")
  Does that help?
  
  Regards,
  Hughes

• 0
  
  Jet Reports Historic Posts November 05, 2013 23:17

  Hi Hughes,
  
  This is just perfect! Thanks lot.
  
  Louise