Skip to main content
oscarhero
oscarhero
Helper ⭐️
February 8, 2019
Solved

date format when uploading data to an MDA object

  • February 8, 2019
  • 5 replies
  • 460 views
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

    Best answer by oscarhero
    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,

    5 replies

    dan_ahrens
    dan_ahrens
    Expert ⭐️⭐️⭐️
    February 8, 2019
    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.



    VP of Customer Success at Forcepoint
      dstokowski
      dstokowski
      Gainsight Employee ⭐️⭐️
      February 8, 2019
      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?

        lila_meyer
        lila_meyer
        Gainsight Employee ⭐️⭐️⭐️
        February 22, 2019
        @oscarhero Please let us know if you still have any questions!

        Lila Krutel, Dir. Global Education Services
        sai_ram
        sai_ram
        Expert ⭐️⭐️
        April 16, 2019
        @oscarhero Is your query answered by our experts or do you need any help here?

        oscarhero
        oscarheroAuthorAnswer
        Helper ⭐️
        April 17, 2019
        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,

          Terms & ConditionsAccessibility statement