How do I establish a date range within a Jet Report formula when the starting date range is in one Excel cell and the ending date range is in a different cell? When I try it changes the formula from A1..A2 to A1:A2 and results in a Value error.
Date
Votes
4 comments
-
Jet Reports Historic Posts Official comment You can also use
=NP("Datefilter",A1,A2) -
Jet Reports Historic Posts I would normally convert the two dates to text and the concatenate them, as the value you are sending to Jet is a text string. Something like this:
=TEXT(A1,"ddmmyy")&".."&TEXT(A2,"ddmmyy")
My Excel is in Danish so forgive me if the syntax is not completely correct. -
Jet Reports Historic Posts Thanks for the replies - I came on today looking for the exact same problem - I can now schedule all of my daily, weekly and monthly reports! :D
-
Jet Reports Historic Posts pls i need some help, how about a formular to retrieve g/l account balance for every month on different columns.
Please sign in to leave a comment.