Hello (simpleton here, please be gentle!),
I have the need to track an asset.
I have two objects in my database, 1) The Asset and 2) The Activity.
The Asset is a fixed purchase with known details such as size and date of manufacture.
The activity is "connected" to the asset to allow the listing of location (it changes regularly), any repairs to a particular asset etc. IT all works well except for one critical part:
I need to record 12 monthly inpsections and be able to search / flag up any asset that is about to expire its 12 months. In the first instance I know the date of manufacture so I can easily know the next inspection due date by using the equation of "date of manufacture" + 365 days. Where I am struggling is for assets that are a few years old - they will have more than one 12 month inspection added in the (2) activity object. How can I make it so that the system only searches for the latest date which could be either the date of manufacture in (1) or the 12 month inspection in (2).
Desperate for help!