How i print Date on row from user define date filter

Jet Reports Historic Posts

March 27, 2015 09:16

None

:roll: Dear All,
I have one query …Actually i want to print list of date from the user define date filter.Suppose user enter date range 010115..050115 in posting date filter on option form.
so i want to print date row wise like that..
Posting Date
Row-1 01/01/15
Row-2 02/01/15
Row-3 03/01/15
Row-4 04/01/15
Row-5 05/01/15
What function should be use for achieving this requirement ..please suggest :roll: :roll: :roll:

Date Votes

3 comments

Jet Reports Historic Posts March 27, 2015 14:49 Official comment

Try this:

=NL("Rows",NP("Date","1/1/15","5/1/15","Month","False"))

I assume you would replace the dates shown with cell references to the dates entered by the user.

Comment actions Permalink
0

Jet Reports Historic Posts March 27, 2015 14:42

You can use NL(Rows) with the Date table in NAV.

rmw

Comment actions Permalink
0

Jet Reports Historic Posts April 01, 2015 07:33

Hii,
Thanks alot for your valuable reply..Its working now with this function:NL("Rows",NP("Dates",G3,G4,"Day","False")) where G3 and G4 are cell reference of date filter given by User..Th :P anks Again Guys.

Regards,
Akhil Tiwari

Comment actions Permalink

Please sign in to leave a comment.