"Invalid date" in Salesforce | XM Community
Skip to main content

Good morning everyone,


I am creating a workflow with tasks to input data from Qualtrics to Salesforce.
I need to configure a total of about 10 fields, all are working correctly except 1.
The field that does not work is a field called "DT_COMPETENCE" whose value is determined through javascript (or current date) and was not configured as "date" in the survey flow but as "text" as otherwise it was creating problems in dashboard.
Within the data and analysis tab, the value displays correctly and, through mapping, in dashboard, we are able to use it correctly to split the data into days/months/years. So, everything is fine.
The only problem is that when we go to pass the field into Salesforce, it is passed as text, but the value that is passed is the text: "invalid date."
How come? Is it possible to see the platform bugs to figure out how to fix the problem?

Thank you
 

Hi @cmagg 

What does your date format look like?

Hi @vgayraud,

the format is DD/MM/YYYY.

Is your SF date field set to European date format?

Salesforce is set up to receive a text value, since we don’t need to use it as a date.

The embedded data in the survey flow is set as text as well, i think the problem occurs cause:
DT_COMPETENCE = ${date://CurrentDate/d%2Fm%2FY}

The problem is that i need DT_COMPETENCE to a be a text.

Leave a Reply


Terms & Conditions