I am trying to convert the Date Created (date_entered) Datetime field to a Date field type.
I am using this Formula: date(subStr(toString($date_entered),0,10))
It populates the field upon creation of an Opportunity BUT when I Edit and Save the Opportunity the value disappears.
When I apply the same type of formula to the Date Modified Field it functions properly even after Editing and Saving.
Any thoughts on how I can resolve this via Studio? I do not want to using custom coding to resolve this issue.
This is the documentation I used for this formula: http://support.sugarcrm.com/Knowledge_Base/Studio_and_Module_Builder/Sugar_Logic/Calculated_Field__Converting_Datetime_t…