Hi everyone, I have 2 fields with a date data type named DATE REQUESTED and DATE RECEIVED and I have an age field which is a formula field. Age is the container of the numbers left off based on the input of Date Requested, It calculates perfectly during creation, the problem when I save the record it reset back to zero. The behavior that I want to create is, even without inputting DATE RECEIVED it will be saved based on the expected value. And for the DATE RECEIVED behavior is already perfect.

Please see the attached video


FORMULA I USED

Datecomp(${Required Documents..Date Received},${Required Documents..Date Requested})/(1440)



Thank you
Partner