Date and Time format required for S3

  • 4
  • Question
  • Updated 4 months ago
  • Answered
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?
Photo of todd.carey

todd.carey

  • 268 Points 250 badge 2x thumb

Posted 1 year ago

  • 4
Photo of Lakshmi Chaitanya

Lakshmi Chaitanya, Product Manager

  • 1,704 Points 1k badge 2x thumb
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:mm:ssZ
yyyy-MM-dd'T'HH:mm:ss.SSS'Z'
yyyy-MM-dd'T'HH:mm:ssz
yyyy-MM-dd HH-mm-ss
yyyy-MM-dd HH:mm: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:mm:ssSSS
yyyy-MM-dd HH:mm:ss
MM-dd-yyyy HH:mm:ss
yyyy-MM-dd'T'HH:mm:ss
yyyyMMdd
MM/dd/yyyy HH:mm: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:mm:ss.SSSZ
yyyy-MM-dd HH:mm: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>
(Edited)
Photo of todd.carey

todd.carey

  • 268 Points 250 badge 2x thumb
Excellent!  Thank you so much for the information.
Photo of Spencer Engel

Spencer Engel, Employee

  • 5,636 Points 5k badge 2x thumb
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.
Photo of Dale Parent

Dale Parent

  • 716 Points 500 badge 2x thumb
+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.