Different Date Submitted – Responce View / Export to CSV



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”)] )

For example:
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 ?

Thank You

Tomek asked

    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.

    Jim Wetherill answered


      Question stats

      • Active
      • Views597 times
      • Answers1 answer
      • Followers0 followers