Issues in Date Format change

[JawaharPrem6]

Hi All,

I have a issues in change the date format from mm/dd/yyyy to dd/mm/yyyy,

in date has 8/12/2023 it is considring in system as mm/dd/yyyy but it should consider as dd/mm/yyyy, sample has pasted. Pls support on this.

MY DATE Format - "dd/mm/yyyy"	Date	MM	YYYY	Remarks
12/12/2023 17:57	12	12	2023	In Date instead of 8, 12 is updated
8/12/2023 21:21	12	08	2023	In Date instead of 8, 12 is updated
8/12/2023 21:21	12	08	2023	In Date instead of 8, 12 is updated
13/12/2023 18:50:36	13/12/2023 18:50:36	13/12/2023 18:50:36	13/12/2023 18:50:36	system format is "mm/dd/yyyy", hence after 12 it change to text format
8/12/2023 21:21	12	08	2023	In Date instead of 8, 12 is updated
29/12/2023 15:56:16	29/12/2023 15:56:16	29/12/2023 15:56:16	29/12/2023 15:56:16	system format is "mm/dd/yyyy", hence after 12 it change to text format
27/12/2023 15:46:16	27/12/2023 15:46:16	27/12/2023 15:46:16	27/12/2023 15:46:16	system format is "mm/dd/yyyy", hence after 12 it change to text format
27/12/2023 14:06:18	27/12/2023 14:06:18	27/12/2023 14:06:18	27/12/2023 14:06:18	system format is "mm/dd/yyyy", hence after 12 it change to text format
27/12/2023 15:11:17	27/12/2023 15:11:17	27/12/2023 15:11:17	27/12/2023 15:11:17	system format is "mm/dd/yyyy", hence after 12 it change to text format

[AlienSx]

hello, @JawaharPrem6 

Table.TransformColumns(tbl_name, {"column_name", each DateTime.FromText(_, [Culture = "de-DE"])})

[JawaharPrem6]

Hi Thanks for your time,

iam facing error 

[AlienSx]

Table.TransformColumns(allocate, {"Received_Date", each DateTime.FromText(_, [Culture = "de-DE"])})

[JawaharPrem6]

Hi, mentioned error listed

[AlienSx]