Contract Expiry Report

[Stephen.whittle]

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)

[AlexTumber]

@Stephen.whittle thanks for your post.

Try the following:

h_end_date < DATE_ADD(CURDATE(), INTERVAL 240 DAY) AND h_end_date > CURDATE()

Alex

[Stephen.whittle]

Hi Thanks for such a quick response. 

It accepts that query but still shows contracts that are expiring far beyond 6 months. 

 

[Victor]

@Stephen.whittle that's not how you implement the expression from Alex

Try like this: Two criterions:

1.

2.

[Stephen.whittle]

@Victor That has worked, thanks for your help and fast response. Much appreciated.