I have a two problems with a response date. I noticed today, that response data results are different depence of the view.
( Hidden Value Action – Value: =[system(“date”)] [system(“time”)] )
1) 23 November 2015 01:34 – individual response result tab (correct)
2) 2015-11-22 19:34:17 – exported file
So as you can see there is a (+/-) 6h time zone difference. How can i change it/setup correct timezone settings ?
Then when we try to use plugin to sent result go google spreadsheet some times we got result: [system(“date”)]. Any advice which form should we use to get date format yyyy/mm/dd hh/mm/ss ?
You can open the ACCOUNT menu, select GENERAL SETTINGS, and set your TIME ZONE.
There is a video in the SurveyGizmo documentation. This is covered at about the 2:11 mark:
There is also an option to change the DATE/TIME FORMATS, but I doubt that this will solve your spreadsheet problem. You are probably going to have to solve this formatting problem within the spreadsheet. I have no experience with Google spreadsheets, so I cannot give you any guidance. In MS Excel we would have to create a custom date format for this requirement.