You need to sign in to do that
Don't have an account?
Cris9931
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?
Try Below Formula DataType Text Please Mark It As Best Answer If It Helps
Thank You!