Date Format Error

Hi adarshmp8998 ,

 

The locale(English United States) you selected doesn't work for dates in "DD-MM-YYYY" format.

Try changing your locale as English (United Kingdom).

Result:

 

Here's how to fix it:

1.Error Scenario for Reverting:

2.Convert the datetime column contains error to a text column.

Select "Replace current".

3.Right click the column, Change Type, Using Locale...

Data Type: Date/Time, Locale: English (United Kingdom)

 

 

Of course, you can also set up a new local in the regional settings and then re-load it, which I think will work as well.

 

 

Best Regards,

Stephen Tao

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.