Hi! I'm trying to write a Jet report (NAV 2016) which will pull Quotes from the Sales Header table, and will be scheduled to run monthly and to show salespeople their quotes that are about to expire. They are asking for the report to include any quotes older than 45 days from =Today() BUT they want to run this monthly so it also has to extend out 30 (or 45) days from =Today(). We're tried various Excel formulas and cannot get this to reliably report the date range we want included. How do you say 'go back 45 days and also forward 45 days from today'? We have a Contract Start date and a contract End date in the report.
Any ideas what the statement should actually be, or how to accomplish this?
Thanks!
-d.
