I have a parent database that contains vehicle information, for example a record of every instance each vehicle in the fleet has visited the workshop including the date of that visit and the work performed.
How do I write a function under a separate field to show the latest date relevant to each vehicle?
Hey @Hector - if your workshop visits are in a related table to the vehicles object you can use the below article to find the Max Value.
Add an equation field in the child object to convert the date to a number. Then in the parent you lookup the max value
Hey @Hector - Hope the knowledge article was of use and it all made sense.
If so, please mark as solved