Forum Discussion
Issues in Date Format change
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 |
5 Replies
hello, JawaharPrem6
Table.TransformColumns(tbl_name, {"column_name", each DateTime.FromText(_, [Culture = "de-DE"])})Hi Thanks for your time,
iam facing error
Table.TransformColumns(allocate, {"Received_Date", each DateTime.FromText(_, [Culture = "de-DE"])})
