Skip to main content
Solved

Date and Time format required for S3

  • June 5, 2017
  • 4 replies
  • 459 views
toddcarey
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?

Best answer by lakshmi_chaitanya

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>
mark_gecsey
toddcarey
spencer_engel

4 replies

lakshmi_chaitanya
  • lakshmi_chaitanya
  • Helper ⭐️⭐️⭐️
  • Answer
  • 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>
toddcarey
toddcarey
  • toddcarey
  • Author
  • Contributor ⭐️⭐️
  • June 6, 2017
Excellent!  Thank you so much for the information.
lakshmi_chaitanya
spencer_engel
Forum|alt.badge.img+5
  • 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.
dale_parent
J
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.
Terms & ConditionsCookie settingsAccessibility statement