Can I automatically generate a date range filter?
I want to enter 010110..013110 as a filter in a cell and then with a have the next cell 020110..022810 through December.
I can do it in two separate cells; 010110 in one cell and 013110 in another but then I cannot get the jet report filter to include the entire range 010110..013110 as the formula changes the entry from cells A1..A2 to A1:A2.
I suspect this is an excel function question but I cannot figure out the proper functio to use. Thanks
Date
Votes
3 comments
-
Jet Reports Historic Posts just to make sure we are thinking the same thing… did you try this? http://community.jetreports.com/viewtopic.php?f=7&t=1419&p=3896#p3896
-
Jet Reports Historic Posts Have you tried using the Excel EOMONTH function ? and then adding 1 day to the result to get start of next month .
If cell D1 is 01/01/2010 EOMONTH(D1,0) should bring back 01/31/2010 add 1 and you get 2/1/2010
so D2 is EOMONTH(D1,0)+1
D3 is np(Datefilter , D1,D2)
Oh and E1 ? Its D2 etc -
Jet Reports Historic Posts Have you tried using the Excel EOMONTH function ? and then adding 1 day to the result to get start of next month .
Easiest solution, but remember you need the "analasys toolpack", which you can check under your excel add-ins (options -> add-ins). By default it is not active, but it is installed.
Otherwise, look into the use of the "Date" table, much more flexible (eg to use quarters and weeks, get month names,…)
Please sign in to leave a comment.