Skip to main content
Topics#Data ManagementAmy Reed의 질문
Amy Reed 님이 #Data Management에 질문했습니다
2018년 3월 8일 오후 1: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개
  1. Steve Dodd (Seeking a new opportunity)
    2018년 3월 8일 오후 2: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.

     

     
답변을 작성하세요...
0/9000