+ Start a Discussion
Alex EichmillerAlex Eichmiller 

Error: Incorrect parameter type for operator '&'. Expected Text, received Date

Hi,
I am trying to create a formula field that concatenates a text field and a date field. Is there anyway around this?

Status__c &" - "& StatusActionDate__c


Thanks,
Alex
Best Answer chosen by Alex Eichmiller
Adam RycroftAdam Rycroft
Are you trying to have the formula return a text value? If so, try

Status__c &"-"& TEXT(StatusActionDate__c)

All Answers

Adam RycroftAdam Rycroft
Are you trying to have the formula return a text value? If so, try

Status__c &"-"& TEXT(StatusActionDate__c)
This was selected as the best answer
Harshit Garg 6Harshit Garg 6
HI Alex,
 
Status__c &"-"& Text(StatusActionDate__c)

Please try this, If that's help you. Please choose my ans as the best ans.

Thanks,
Harshit Garg
Alex EichmillerAlex Eichmiller
Thank you both!