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 https://jetsupport.jetreports.com/hc/en ... 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 http://support.jetreports.com. Staff responses to posts on the forum are not guaranteed.
YJury
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""))")

Thanks.

User avatar
HPDeskJet
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:
month_format.png
-HP
_______________________
Jet 2015 Certified Trainer


Return to “How do I?”

Who is online

Users browsing this forum: No registered users and 2 guests