Hello, 

I have added a hidden time stamp in the comment box of my list with comment question.

I was wondering if there is any way to make it so that when I export my participant data into SPSS the time stamp can appear as a date type variable rather than as a string type variable?

Hi,
it's a bit late now.
You get the full "Date()" exported like "Thu Feb 18 2021 10:10:29 GMT+0100 (Mitteleuropäische Normalzeit)".
To store this you used 
What do you need for your idea to find out when a question was asked? Only the time.
If you'd have stored only the time with  you would have got still a string like "9:39:23".
But this you can switch to format "date" in SPSS with two clicks.

Other approach:
In your survey use some equations to extract the time from that "Date()" string, like {trim(substr(Q1_comment,16,)}

These are LimeSurvey specific solutions.

Now the other way:
Compute it in SPSS
COMPUTE Q1_T=RTRIM(CHAR.SUBSTR(Q1_comment,17,).
EXECUTE.

This you can add at the end of your syntax file and everything is done while importing into SPSS.
Afterwards it is still a string. But with two clicks you can switch the format to "date".

Joffm

By the way:
I still think that this approach (with the hidden time) was really not the very best to find out the order of the random questions.

Not only to say "not the best approach", but to show something.

In a last (hidden) question of type "multiple numerical input" set the default answers to
{(AF37.qseq-1)/3-1}
{(Af19.qseq-1)/3-1}
...
(This formula fits your provided survey. You may adapt it or just leave {AF37.qseq} ...)

Then you get the order of the questions 
 

Joffm

 

Thank you I am still piloting the survey. I will try your solutions and get back to you on their effectiveness.

Your help is very appreciated.