Change date format in excel export

0

Hi is it possible to change the date format in the excel export. The current format is yyyy-mm/dd hr:mm:ss. We would like it to be dd/mm/yyyy.

 

Is it possible to change this in the export file, so I don’t have to manually make the change inside excel.

 

/Catharina

Admin - SurveyGizmo answered
    1

    Hi Catharina,

    Depending on what date you are referring to you can change the date format at the question, project, and surveygizmo account level. 

    Question level: See this turtorial http://help.surveygizmo.com/help/article/link/date

    Project level: from within your survey go to the tab Advanced>General>Project Date Format

    Account Level: from your SurveyGizmo homepage at the top right, go to Account>Account Settings>Date/Time Formats

    Mary

    Mary L (Moderator) answered
      0

      Hi all,

      Thank you all for contributing to this thread!

      SurveyGizmo did release an update to this functionality that should help with many if not all of these requests. The CSV Exports now display the Time Started and Date Submitted fields in the format that you have specified under your Account Settings:

      https://help.surveygizmo.com/help/account-time-zone

      Exports are one of the supported features listed here:

      https://help.surveygizmo.com/help/account-time-zone#supported-features

      I hope this is helpful!

      Best regards,

      David Domagalski
      Survey Explorer & Documentation Specialist
      SurveyGizmo | http://surveygizmo.com

      Admin - SurveyGizmo answered
        0

        Hi,

        I just want to highlight that it is an extreme annoyance to have to alter date formatting in Excel for the way we use SG. And if a solution has been developed since Mar 2016 I’d be very grateful to hear about it?

        Thank you,

        G

        Graham Frickers answered
          0

          Hi Mary

           

          I’m looking to have the Date Submitted in my export files to be in the format dd/mm/yyyy and without the hours time stamp.

           

          On both my Account and on the Project level I’ve set it at dd/mm/yyyy. However in the export file it still states yyyy-mm-dd hr:min:sec.

           

          Is it possible to secure that the export file is shown with dd/mm/yyyy without having to make this setting in the Excel after the file have been downloaded.

          I’m asking because my IT department is using the exort direc link to import directly into our CRM system.

           

          /Catharina 

           

           

          Catharina Brodka answered
            0

            Hi Jan

             

            Yes I know it is possible to change this on Excel. The issue is that my IT department is using a direct link to feed the information into our CRM system, so they were looking for this possibility so they don’t have to this manually.

            Thank ou for yow answer. I’ll let them know that this is not a possibility.

             

            /Catharina

            Catharina Brodka answered
              ×

              Login

              Question stats

              • Active
              • Views6440 times
              • Answers7 answers
              • Followers1 follower