Different Date Submitted – Responce View / Export to CSV

0

Hello,

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
Tomasz

Tomek asked
    0

    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:

    https://help.surveygizmo.com/help/article/link/video-intro-to-surveygizmo-account

    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
      ×

      Login

      Question stats

      • Active
      • Views597 times
      • Answers1 answer
      • Followers0 followers