Skip to main content The new Salesforce certifications experience is live! Visit Trailhead Academy to explore your new certifications homepage.
Topics#Data ManagementSFDC Admin's Question
SFDC Admin (--) asked in #Data Management
May 10, 2021, 8:37 PM

date value from text field containing timestamp

Have a custom text field that was created to meet criteria from another system we are pulling data from. I need the formula to convert 4/15/2021 7:27:30 PM to just the MM/DD/YY. The DATEVALUE formula doesn't provide anything, just a blank value. 
12 answers
Loading
  1. Keiji Otsubo (Fukada Electric Co.,Ltd.)
    May 10, 2021, 10:30 PM
    Hi

     

    Try this

     

    DATE( VALUE(right( left(Last_User_Agreement_Timestamp__c,FIND(' ', Last_User_Agreement_Timestamp__c )-1) ,4)) ,VALUE(left(left(Last_User_Agreement_Timestamp__c,FIND(' ', Last_User_Agreement_Timestamp__c )-1),FIND('/', left(Last_User_Agreement_Timestamp__c,FIND(' ', Last_User_Agreement_Timestamp__c )-1) )-1)),VALUE(left(MID( left(Last_User_Agreement_Timestamp__c,FIND(' ', Last_User_Agreement_Timestamp__c )-1) , FIND('/', left(Last_User_Agreement_Timestamp__c,FIND(' ', Last_User_Agreement_Timestamp__c )-1) ) + 1, LEN( left(Last_User_Agreement_Timestamp__c,FIND(' ', Last_User_Agreement_Timestamp__c )-1) )),FIND('/', MID( left(Last_User_Agreement_Timestamp__c,FIND(' ', Last_User_Agreement_Timestamp__c )-1) , FIND('/', left(Last_User_Agreement_Timestamp__c,FIND(' ', Last_User_Agreement_Timestamp__c )-1) ) + 1, LEN( left(Last_User_Agreement_Timestamp__c,FIND(' ', Last_User_Agreement_Timestamp__c )-1) )) )-1)))
Write an answer...
0/9000