Skip to main content
Topics#Data ManagementPregunta de Amy Reed
Amy Reed ha preguntado en #Data Management
8 mar 2018, 13:56

Text Field that Contains a Date to a Date Field

I have a text field with a date, in the mm/dd/yyyy format. I need to use this field to populate a date field. How would I do this?
3 respuestas
  1. Steve Dodd (Seeking a new opportunity)
    8 mar 2018, 14:30
    Amy,

     

    If you just need to add a Date field to the object that displays the same information as your Text field, you can do this by creating a formula field:

     

    Formula Data Type = Date
    DATE(
    VALUE("20"&RIGHT(Text_Date__c, 2)),
    VALUE(LEFT(Text_Date__c, 2)),
    VALUE(MID(Text_Date__c, 4, 2))
    )

    * Use the

    Insert Field button when composing the formula to select the correct field API name (I'm guessing on Text_Date__c)

     

    If you already have a traditional Date field on the object that you want to update when the Text Date field is populated, you can use either a workflow rule or Process Builder to do a field update using the above formula.

     

     
Escribir una respuesta...
0/9000