Alloy Ideas Portal

Welcome to the Alloy Ideas Portal đź‘‹ Here, you'll be able to browse improvement ideas raised by our community, vote on ideas you agree with or even raise your own ideas. We review all ideas raised and we endeavour to respond to all raised ideas.

Any ideas submitted will be immediately visible on the portal for others to vote on, please do not include anything in your ideas you do not wish to be shared with others.

Add a new idea Subscribe
Status Will not implement
Product Alloy Web
Created by Guest
Created on Aug 4, 2022

RELATED IDEAS

Fix the date/time attributes when exporting for use in other software

At present when the this type of date is exported it is current 1 hour behind what it should be and also the format of the data/time field is in such a format that it excel won't format it straight out of the box with out splitting it down.

  • ADMIN RESPONSE
    Aug 8, 2022

    Unfortunately, there's not much we are going to be able to do here as we are tied to providing date time stamps in ISO-8601 format. This is to avoid providing different data exports depending on the timezone in which someone exports data.

  • Attach files
  • Guest
    Reply
    |     Nov 9, 2022

    When loading the data in Excel don't open the CSV. Go to the Data tab > New Query > from File > From CSV and select the CSV file. This for me, opens the CSV and converts the date time to local date time without intervention. If your set to a different time zone you can click edit on the import and right click on the column and select change type > to local.

  • Tom H
    Reply
    |     Sep 13, 2022

    I found some useful information about this subject on someone's blog, might help.

    https://weblog.west-wind.com/posts/2014/jan/06/javascript-json-date-parsing-and-real-dates

  • Guest
    Reply
    |     Aug 9, 2022

    There is something you could do and I suspect all UK users would want this, but I feel it fits in that to hard box, rather then looking for a solution to a problem that exists.