Get Last Date a checkbox was checked
I have a database where field technicians log in and check boxes (boolean field) to mark specific types of maintenance (different fields) for specific sites (from a drop down value list). I would like to create fields that house a calculation that when a site is selected, fields populate for each type of maintenance indicating the date maintenance was last performed (last checked the checkbox). I've come up with some long messy solution but all have big problems. Any help would be greatly appreciated! Thanks!