Pull the latest value from a field based on date

Hi

Is there a way to pull a record value based on the latest submission date. In the example attached I would need to use the value 2445 in an equation.

Hi Georgio:

If this screen is Detail, you must have a Master, then you can create a field in the master to save this value "REQUIRED" , (the last adjustment) , you can do this in the form that add a new adjustment, in record rules "Update connected values" : select the master of the detail, then the fields of master will appear, select the field "REQUIRED" and select "to a form value" and select the field "Adjustment Required" and then when you capture de next adjustment this will be updated in the master, and then you can make an equation.

This only will work if the date of submitted is generated by system.