example 1: [question(“value”), id=”29″,format=”Y-m-d”]
example 2: [system(“date”),format=”Y-m-d”]
I can’t figure out the syntax to make example 1 work. Example 2 works without a problem!
Ok, the script is clear to me now, so I tried the first test but got a bad syntax error.
Custom scripts are scary at first, but once you understand them you really start to see possibilities.
Give it a try – insert an ACTION > CUSTOM SCRIPT on the survey page after the date question and copy/paste this script:
%%xdate = sgapiStrtotime(sgapiGetValue(29));
%%xdate = sgapiDate(“Y-m-d”,%%xdate);
%%output .= %%xdate;
The OUTPUT command should cause the date that was entered into qid29 to appear on the page in the YYYY-mm-dd format. If it works, your next step should be to replace the OUTPUT command with a line that places the xdate as a response to a question:
The question marks (??) should be replaced by the question ID. If you don’t want your respondent yo see the question then you can edit the question and use LOGIC RULE > HIDE THIS QUESTION BY DEFAULT. This question would be the one that you pass to your application.
I’m just passing it to another application which expects a text string which looks like YYYY-MM-DD.
If I were facing a similar problem in Excel, I’d start doing things like (left, 4 characters), (right, 2 characters) etc. and then piece it back together.
Is that more or less hassle than custom scripting – as I’m not at all familiar with scripting?