Skip to main content
oscarhero
oscarhero
Helper ⭐️
Feb 8, 2019 1:01 PM UTC
Solved

date format when uploading data to an MDA object

I've finally understood exactly how to upload data using the S3 connector to and MDA object. however, I was quite surprised when I was troubleshooting and searching the gainsight support site that formats starting with day (dd/MM/yyyy or dd-MM-yyyy) are not at all supported. this becomes incredibly annoying for me and our CSMs since we're based in Europe and most of our data in Salesforce uses this formatting instead of the classic American MM/dd/yyyy. It would be very nice and much more manageable if we could have this format supported. Thank you

    oscarhero
    oscarheroAnswer
    Helper ⭐️
    Apr 17, 2019 9:15 AM UTC
    yes I'm sorry. it seems I must've had some other error that was messing up the formatting and it worked fine for later uploads.

    thanks,

    View in thread

    5 replies

    dan_ahrens
    dan_ahrens
    Expert ⭐️⭐️⭐️
    Feb 8, 2019 3:48 PM UTC
    Hi Oscar,

    Did you review this support page : https://support.gainsight.com/Rules_Engine/Admin_Guides/S3_Dataset_Task_in_Bionic_Rules

    The subheading Columns discusses file types and date types. Multiple format types are supported for date, including dd/MM/yyyy.



    Translate
    VP of Customer Success at Forcepoint
      dstokowski
      dstokowski
      Gainsight Employee ⭐️⭐️
      Feb 8, 2019 4:06 PM UTC
      We recommend using the S3 Dataset task to bring in the data vs the S3 Connector. That is the article that Dan references and should support the date types you are hoping to use. Were there other areas (in addition to S3) where you are having a date formatting issue?

      Translate
        lila_meyer
        lila_meyer
        Gainsight Employee ⭐️⭐️⭐️
        Feb 22, 2019 8:01 PM UTC
        @oscarhero Please let us know if you still have any questions!

        Translate
        Lila Krutel, Dir. Global Education Services
        sai_ram
        sai_ram
        Expert ⭐️⭐️
        Apr 16, 2019 9:53 AM UTC
        @oscarhero Is your query answered by our experts or do you need any help here?

        Translate
        oscarhero
        oscarheroAuthorAnswer
        Helper ⭐️
        Apr 17, 2019 9:15 AM UTC
        yes I'm sorry. it seems I must've had some other error that was messing up the formatting and it worked fine for later uploads.

        thanks,

        Translate
          Terms & ConditionsAccessibility statement