Skip to main content
toddcarey
toddcarey
Contributor ⭐️⭐️
June 5, 2017
Solved

Date and Time format required for S3

I can't locate anything that defines what formats Gainsight accepts for Date type or Date and Time types in the MDA.  Does anyone know or know of a document that helps with these requirements for .csv imports?
    lakshmi_chaitanya
    lakshmi_chaitanyaAnswer
    Helper ⭐️⭐️⭐️
    June 6, 2017
    Hi Todd,

    The Date and Time formats supported in MDA(S3 Connector) are as follows :

    M-d-yy HH:mm
    MM-dd-yy HH:mm
    MM-d-yy HH:mm
    M-dd-yy HH:mm
    M-d-yy
    MM-d-yy
    M-dd-yy
    M/d/yy HH:mm
    MM/dd/yy HH:mm
    MM/d/yy HH:mm
    M/dd/yy HH:mm
    M/d/yy
    MM/d/yy
    M/dd/yy
    yyyy-MM-dd'T'HH🇲🇲ssZ
    yyyy-MM-dd'T'HH🇲🇲ss.SSS'Z'
    yyyy-MM-dd'T'HH🇲🇲ssz
    yyyy-MM-dd HH-mm-ss
    yyyy-MM-dd HH🇲🇲ss.S
    yyyy-MM-dd:HH-mm-ss
    MM-dd-yyyy
    yyyy-MM-dd
    yyyy-M-d
    M-d-yyyy
    MM/dd/yyyy
    yyyy/MM/dd
    yyyy/M/d
    M/d/yyyy
    yyyy-MM-dd'T'HH🇲🇲ssSSS
    yyyy-MM-dd HH🇲🇲ss
    MM-dd-yyyy HH🇲🇲ss
    yyyy-MM-dd'T'HH🇲🇲ss
    yyyyMMdd
    MM/dd/yyyy HH🇲🇲ss
    M/dd/yyyy
    MM/d/yyyy
    M/dd/yyyy HH:mm
    MM/dd/yyyy HH:mm
    MM/d/yyyy HH:mm
    M/d/yyyy HH:mm
    M-dd-yyyy
    MM-d-yyyy
    M-dd-yyyy HH:mm
    MM-dd-yyyy HH:mm
    MM-d-yyyy HH:mm
    M-d-yyyy HH:mm
    yyyy-MM-dd'T'HH🇲🇲ss.SSSZ
    yyyy-MM-dd HH🇲🇲ssZ<br><br>"Currently we are accepting&nbsp;<b>UTC as a timezone during data load in MDA</b>&nbsp;,In the coming release we are making the enhancement to extend timezone support"&nbsp;<br><br>Thanks and Regards,<br>Lakshmi<br><br>
    View in thread

    4 replies

    lakshmi_chaitanya
    lakshmi_chaitanyaAnswer
    Helper ⭐️⭐️⭐️
    June 6, 2017
    Hi Todd,

    The Date and Time formats supported in MDA(S3 Connector) are as follows :

    M-d-yy HH:mm
    MM-dd-yy HH:mm
    MM-d-yy HH:mm
    M-dd-yy HH:mm
    M-d-yy
    MM-d-yy
    M-dd-yy
    M/d/yy HH:mm
    MM/dd/yy HH:mm
    MM/d/yy HH:mm
    M/dd/yy HH:mm
    M/d/yy
    MM/d/yy
    M/dd/yy
    yyyy-MM-dd'T'HH🇲🇲ssZ
    yyyy-MM-dd'T'HH🇲🇲ss.SSS'Z'
    yyyy-MM-dd'T'HH🇲🇲ssz
    yyyy-MM-dd HH-mm-ss
    yyyy-MM-dd HH🇲🇲ss.S
    yyyy-MM-dd:HH-mm-ss
    MM-dd-yyyy
    yyyy-MM-dd
    yyyy-M-d
    M-d-yyyy
    MM/dd/yyyy
    yyyy/MM/dd
    yyyy/M/d
    M/d/yyyy
    yyyy-MM-dd'T'HH🇲🇲ssSSS
    yyyy-MM-dd HH🇲🇲ss
    MM-dd-yyyy HH🇲🇲ss
    yyyy-MM-dd'T'HH🇲🇲ss
    yyyyMMdd
    MM/dd/yyyy HH🇲🇲ss
    M/dd/yyyy
    MM/d/yyyy
    M/dd/yyyy HH:mm
    MM/dd/yyyy HH:mm
    MM/d/yyyy HH:mm
    M/d/yyyy HH:mm
    M-dd-yyyy
    MM-d-yyyy
    M-dd-yyyy HH:mm
    MM-dd-yyyy HH:mm
    MM-d-yyyy HH:mm
    M-d-yyyy HH:mm
    yyyy-MM-dd'T'HH🇲🇲ss&#46;SSSZ
    yyyy-MM-dd HH🇲🇲ssZ<br><br>"Currently we are accepting&nbsp;<b>UTC as a timezone during data load in MDA</b>&nbsp;,In the coming release we are making the enhancement to extend timezone support"&nbsp;<br><br>Thanks and Regards,<br>Lakshmi<br><br>
    Translate
      toddcarey
      toddcareyAuthor
      Contributor ⭐️⭐️
      June 6, 2017
      Excellent!  Thank you so much for the information.
      Translate
        spencer_engel
        spencer_engel
        Expert ⭐️
        October 20, 2017
        Hi Lakshmi - Do you know if there are any plans to support any format that would only be 1 h in it? 

        i.e. MM-dd-yyyy h:mm

        This would be very helpful for one of my current customers, and I've noticed via Zendesk tickets that other customers have asked for this functionality as well.
        Translate
          dale_parent
          dale_parent
          Helper ⭐️
          May 27, 2018
          +1

          I was initially unable to load data to mda because the default csv datetime format does not put a zero in front of hours less than 10.  I was able to work around this for a manual load by customizing the format of that column in excel.  It would greatly enhance automation of data loads to add support for the above format Spencer suggests.
          Translate
          Terms & ConditionsAccessibility statement