Skip to main content Take our 5-minute Community Survey. Open now through 4/11/2025. Click here to participate.
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
  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)))
  2. SFDC Admin (--)
    May 10, 2021, 11:30 PM
    WINNER!!! Thank you!! I would have never gotten to this formula haha. As always Keiji you come through with the correct date/time formulas and I'm supremely grateful
  3. SFDC Admin (--)
    May 10, 2021, 9:46 PM
    Yes a value will always be enteredYes a value will always be entered
  5. SFDC Admin (--)
    May 10, 2021, 9:33 PM
    Still not working :( designated field is blank
  7. SFDC Admin (--)
    May 10, 2021, 9:24 PM
    It is...sorry I think when its viewing from just the saved view it changes it. Below is the true formula format

     

    It is...sorry I think when its viewing from just the saved view it changes it.
  9. SFDC Admin (--)
    May 10, 2021, 9:17 PM
    Still showing as blank :\

     

    Account Page Layout

     

    Still showing as blank :\ Account Page Layout Field config 

     

    Field config

     

    User-added image
Write an answer...
0/9000