Stephen.whittle Posted June 19, 2020 Share Posted June 19, 2020 Need some help on a contract report, we have compiled lots of our suppliers and associated contracts in the supplier manager module and use the contracts view to view a list of when contracts are due to expire. The limitation of this is the view is fixed to only show contracts that expire within 30, 60 and 90 days. There are some very high value contracts that we would need to start a procurement exercise for within 6 months of expiry and therefore I want a report that sends these by email to specific parties. I have created the report but struggling with the filter that only resolves contract end dates within 240 days. I am using this as a custom criteria that I have lifted from another report but it must be wrong. I need to show only contracts that expire within 240 days of "todays date" at the point in which the report is executed. DATE_SUB(NOW(), INTERVAL 240 DAY) Link to comment Share on other sites More sharing options...
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!Register a new account
Already have an account? Sign in here.Sign In Now