I am trying to create two things:
- I want to use the survey create date and import that date to Salesforce. There is a Salesforce create date but this is a custom field. I don’t want to create a formula in Salesforce because the formula is not the same for record types that are not generated through Survey Gizmo. For this, I tried using the hidden value action: [system(“date”)] but that did not work.
- I want to create a formula based on the survey complete date and add xxx days to it. I would then like to import that date to Salesforce. I do not want to create the formula in Salesforce for the same reason as #1.
- Try this format: [system(“date”),format=”Y-m-d”]. This works for me when pushing dates to SalesForce.
- You could accomplish this with custom scripting and a hidden value field. Do you have someone on your team with knowledge of PHP Code? Convert the date to a Unix timestamp with this function, sgapiStrtotime(%%string,%%time) then write code to add the day amount, and set the value of a hidden value field. (http://script.surveygizmo.com/help/article/link/sgapistrtotime)