Give access to individual responses without editing rights

0

Hi 

 

How do I get the date in my export file to display DD/MM/YYYY, the way I’ve set it up under the validation tab?

In my CSV file, it’s displaying MM/DD/YYYY.

http://app.surveygizmo.com/reportsview/?key=187251-5370194-0063ba6d48a671a185df3e23c1a86ae6&realtime=true

I’d really appreciate your advice :)

Many thanks

Tamsin

Web Centre asked
    0

    Hi, Tamsin!

    Thanks for the post! If you have validation set for your question to produce DD/MM/YYYY answers, the export will provide that format for you, but only for the question. Becuase the server is located in the US, the date submitted and date started will always be in MM/DD/YYYY.

    Sadly, the Account Settings will only apply for the application setting, for example Individual Responses (http://screencast.com/t/hEYE4SrZGSG)

    You are always more than welcome to change the format in Excel once it is exported, though! Here is a link that will show you how to do that:)

    Excel date format change

    Hope this helps!
    Seanalee

    Survey Princess

    seanalee flaherty answered
      ×

      Login

      Question stats

      • Active
      • Views452 times
      • Answers1 answer
      • Followers0 followers