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?
Page 1 / 1
Hi Todd,
The Date and Time formats supported in MDA(S3 Connector) are as follows :
M-d-yy HH:mm
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'HHssZ
yyyy-MM-dd'T'HHss.SSS'Z'
yyyy-MM-dd'T'HHssz
yyyy-MM-dd HH-mm-ss
yyyy-MM-dd HHss.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'HHssSSS
yyyy-MM-dd HHss
MM-dd-yyyy HHss
yyyy-MM-dd'T'HHss
yyyyMMdd
MM/dd/yyyy HHss
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'HHss.SSSZ
yyyy-MM-dd HHssZ<br><br>"Currently we are accepting <b>UTC as a timezone during data load in MDA</b> ,In the coming release we are making the enhancement to extend timezone support" <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.
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.
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
Sign up
If you ever had a profile with us, there's no need to create another one.
Don't worry if your email address has since changed, or you can't remember your login, just let us know at community@gainsight.com and we'll help you get started from where you left.
Else, please continue with the registration below.
Welcome to the Gainsight Community
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.