Changing Date Format On Import CSV Or Excel

Unknown

Changing Date Format On Import CSV Or Excel

Unknown

We are importing Data from a CSV file.

Decisions is not accepting Dates in dd.mm.yyyy format. If I change the Dates to mm.dd.yyyy format, the data imports fine. We are going to use the dd.mm.yyyy format in our project. How can we change the default format for Dates?
[i]edited by kshitij@decisions.com on 5/30/2019[/i]

Unknown

[color=rgb(34, 34, 34)]
You can specify Custom Date/Time Format for your Date mapping on the Import CSV or Excel step. Please refer screenshots.

[img]https://i.imgur.com/I7LWSBa.png[/img]

[img]https://i.imgur.com/1VZq34S.png[/img]

[/color]