Skip to main content
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?
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>
Excellent!  Thank you so much for the information.
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.
+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.

Reply