NL Rows question

Questions and Answers asked by users to users, about how others use Jet Reports.

For additional "how to" information, please visit our online Knowledge Base ... ofessional
Forum rules
The Jet Reports Community forums are not a guaranteed support medium. Official support for Jet Reports is available only through the support desk at Staff responses to posts on the forum are not guaranteed.
Posts: 20
Joined: Wed Sep 09, 2015 9:56 am

NL Rows question

Postby YJury » Wed Apr 26, 2017 12:25 pm

Is it possible to use an Excel formula around a field name in an NL rows function? What I want to do is get the month of a date only, not the entire date.
I'm trying to do it like this, and it doesn't work. I don't know if the syntax is incorrect or if it's just not possible.

=NL("Rows","Production Order","MONTH(NF(,""starting date""))")


User avatar
Jet Reports Certified Professional
Posts: 442
Joined: Wed May 26, 2010 3:40 pm

Re: NL Rows question

Postby HPDeskJet » Mon May 01, 2017 7:19 am

You could just return the date field and format the cell for month name only:
Jet 2015 Certified Trainer

Return to “How do I?”

Who is online

Users browsing this forum: No registered users and 6 guests