AnsweredAssumed Answered

Converting Datetime to Date for the Date Created Field

Question asked by Philip Scott on Mar 3, 2017
Latest reply on Oct 5, 2017 by Patrick McQueen

Hello,

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… 

 

Thanks

Outcomes