In my JET options tab I need to specify that I want to see all items "delivered" within the past 90 days of todays date or with no date in the "delivered" field. I tried this, no worky.
NOW()-90|""
Any help appreciated!!
Date
Votes
3 comments
-
Jet Reports Historic Posts Official comment E5 = NP("Eval","=NOW()") - 90
E6 = NP("Format",E5) & "|''" -
Jet Reports Historic Posts Hi
Im guessing the reason why it aint working is because NAV cant understand excel expressions like "NOW()-90".
Do you always want to use the "delivered within the past 90 days" or is that just a temp. option?
-Søren -
Jet Reports Historic Posts that should do it, thanks! Appreciated!
Please sign in to leave a comment.