Solved

Date and Time format required for S3

  • 5 June 2017
  • 4 replies
  • 201 views

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?
icon

Best answer by lakshmi_chaitanya 6 June 2017, 04:30

View original

4 replies

Userlevel 3
+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.
Userlevel 7
Badge +1
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.
Excellent!  Thank you so much for the information.
Userlevel 4
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>

Reply