Filtering the latest date for each child record

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 :+1:

Got it! Tx

1 Like

Hey @Hector - Hope the knowledge article was of use and it all made sense.

If so, please mark as solved :100: :white_check_mark: :+1: