Any plans to support dd-mm-yyyy date or date/time formats?

  • 7
  • Idea
  • Updated 3 months ago
  • Under Consideration
I have a customer in Europe who is trying to use DD-MM-YYYY as their date format. We only support MM-DD-YYYY format in the MDA right now, but with more and more European customers coming on board, it would be nice to support DD-MM-YYYY. Any plans on that? 

Also, any suggested approaches for getting around this?
Photo of Spencer Engel

Spencer Engel, Employee

  • 5,638 Points 5k badge 2x thumb

Posted 8 months ago

  • 7
Photo of Reivick Giuliani

Reivick Giuliani

  • 60 Points
Thanks Spencer. This would be very useful indeed. 
Photo of Sam Buddery

Sam Buddery, Employee

  • 420 Points 250 badge 2x thumb
I can confirm that our EMEA customers would like this
Photo of Kunal Bhat

Kunal Bhat, Employee

  • 982 Points 500 badge 2x thumb
Hi Spencer/Reivick/Sam,

This is definitely something we can look into it. Just to get some insight, do you think it would work if we provide the option to specify the date format when the Date/DateTime field is mapped? This could help us resolve the potential ambiguity between MM/DD and DD/MM.

This also means that the source data within a single ingest job couldn't have multiple date formats if you've chosen to explicitly specify the format. Do you see this solving your use cases?