+ Start a Discussion
Cris9931Cris9931 

Formula field showing #Error

Hi, I've built a formula field of datatype(Date/Time) out of 2 fields: Start Date and Start Time. Formula looks like this:

 

DATETIMEVALUE(TEXT(YEAR(SVMX_PS_Customer_Start_Date__c)) + " - " + TEXT(MONTH(SVMX_PS_Customer_Start_Date__c )) + " - " +
TEXT(DAY(SVMX_PS_Customer_Start_Date__c)) + " " + LEFT(TEXT(SVMX_PS_Customer_Start_Time__c), 2)  + MID(TEXT(SVMX_PS_Customer_Start_Time__c),3,3) + ":00")


However in the page it I have the #Error. I made sure that the Start Date and Start Time are populated. Can anyone tell me why I have this Error on the page?   

 

User-added image

Best Answer chosen by Cris9931
CharuDuttCharuDutt
Hii Chris
Try Below Formula DataType Text
TEXT(YEAR( date_1__c ))+'/'+ TEXT(MONTH(date_1__c ))+'/'+
TEXT(DAY(date_1__c ))+' '+ TEXT(HOUR(Time_1__c ))+':'+TEXT(MINUTE(Time_1__c ))+':'+TEXT(SECOND(Time_1__c))
Please Mark It As Best Answer If It Helps
Thank You!