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")
5 answers