Get Soonest Date from Column in Child Table and Save in Parent?

How can I check all dates in a Child table column and return the date that is closest to the present, then copy that date to a field in the Parent DocType on save?

Thanks,
Paul