Skip to main content

Could anyone help me create this formula into a Date/Time instead of text result

 

TEXT(MONTH(Start_Date_Cstm_Date__c))+ "/" + TEXT(DAY(Start_Date_Cstm_Date__c)) + "/" + TEXT(YEAR(Start_Date_Cstm_Date__c)) + " " + IF(Value(LEFT(TEXT(Start_Time__c), 2))==0, "12", IF(Value(LEFT(TEXT(Start_Time__c), 2))>12, TEXT(Value(LEFT(TEXT(Start_Time__c), 2))-12),Text(Value(LEFT(TEXT(Start_Time__c), 2))))) + MID(TEXT(Start_Time__c),3,3) + " " + IF(Value(LEFT(TEXT(Start_Time__c), 2))>=12, "PM", "AM")

 

@Formulas - Help, Tips and Tricks

5 answers
  1. Oct 13, 2021, 3:53 AM

    Hi

     

    Try this

     

    TEXT( Start_Date_Cstm_Date__c ) + " " + LEFT(TEXT( Start_Time__c ),8)

0/9000