Why the heck can i not add a refrence to a cell for a date filter. When i add the date filters through the cell refrence it does not work but when i add the actual date the filter works as expected….
Date
Votes
1 comment
-
Jet Reports Historic Posts Looking at your screen shot, it looks like you have your cell reference quoted. The argument you have is ">A6" which is just a string to Excel and will be passed to Jet as a string. Thus it doesn't work because the string "A6" is not in fact a date. You need to actually combine the string ">" with what is inside cell A6 using Excel concatenation, which would be something like this: ">"&A6.
However, given that Excel turns dates into numbers when they get referenced, this may not work either. There is a convenient Jet formula which should work for you called NP(DateFilter). So your argument in this case would be NP("DateFilter",A6,A7). Note that you might have to adjust your date in A6 since the result of NP(DateFilter) will be >= instead of just >. Also, you can't filter on the same field twice the way you are doing in your screenshot, so you have to combine the filter.
Regards,
Hughes
Please sign in to leave a comment.