Is there any kind of work-around to be able to convert a date in a string field to a true date field

Forum|Forum|6 years ago
September 11, 2019
2 replies
365 views

I know from this discussion (https://community.gainsight.com/conversations/date-field-gainsight-survey-5bc73e0ce4b04588aaf86072) we don't have the option for a date response from surveys today. We have a 'next filing date' field in Salesforce that we are really hoping to populate based on responses to a survey question. IF the participant responds in a standard MM/DD/YYYY format, is there a way we can convert this to be able to use a rule to populate a date field?

surveys

Best answer by anton_vinny

Hi Katie,

Since you are loading to salesforce, one option would be to create the target field as string field and create a new formula field to parse that string value to date format. (or use some trigger to populate a normal date field)

https://success.salesforce.com/answers?id=9063A0000019UiAQAU

If you need to do it with rule itself, you will have to use 2 rules. One rule to load the data to S3 bucket and then another to read the csv file from S3. While reading, you can configure the field as date and define the format.

anton_vinnyAnswer

Gainsight Employee ⭐️

Hi Katie,

Since you are loading to salesforce, one option would be to create the target field as string field and create a new formula field to parse that string value to date format. (or use some trigger to populate a normal date field)

https://success.salesforce.com/answers?id=9063A0000019UiAQAU

If you need to do it with rule itself, you will have to use 2 rules. One rule to load the data to S3 bucket and then another to read the csv file from S3. While reading, you can configure the field as date and define the format.

katie_bAuthor

Helper ⭐️

Thanks, I think I'll be getting our SF team involved in this one.

Katie Baker

Didn't find what you were looking for?

Sign up

Welcome to the Gainsight Community