I have a custom module I have created for construction and property based transactions. One of the functions that is increasingly becoming more and more important is the ability to automatically populate dates based on dates within the same module.

For example field 1) is updated with a date. I would like fields 2) 3) and 4) to also be updated based on the date that is entered into field 1).

Here is what I have tried:

I can create a formula to auto-populate each field but then the fields are locked from editing (sometimes the dates for Fields 2, 3 & 4 might change).

I am now at creating a rule to automatically populate the other fields and I can do this using the tag ${EXECUTION_TIME} but I want to do it from the date that is entered into the field? Todays date might be 18/11/2014 but the date entered into the field might be 01/11/2014. I want it to read the field entered not the execution time.

Hoping for a solution from the Guru's on here.

Thanks in advance.