Date Format Error

[adarshmp8998]

Hi All,

My date-time format is the same still getting an error.

Regional Setting:

[Anonymous · Accepted solution]

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.           

[Ahmedx]

Share sample pbix file to help you.