do you want to just duplicate the field? Or only copy it if certain conditions are true?
To simply copy it you can create a field of the same type (datetime) in Studio, make it formula based, and put date_modified (check the exact field as it may be different depending on the module developer) into your formula with no other conditions or formulas added.
However, I don't quite see how that would be useful, so I wonder if you are wanting to copy it just under certain conditions.
Using Sugar Logic with no calculation conditions might deliver another custom Date Modified field for you, and they both, the copy and the original one, might be updated simultaneously.
In case you need to make a snapshot of the previous Date Modified value, try to configure before_save logic hook in which specify copying the last Date Modified field value to a custom datetime field
Best Regards, Dmytro Chupylka
integroscrm.com We make work in Sugar CRM system faster, more convenient and efficient
