Skip to main content
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



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.










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?




@oscarhero Please let us know if you still have any questions!




@oscarhero Is your query answered by our experts or do you need any help here?




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,




Reply