Forum Discussion
Helper VChnage Date for from Text (with differnet Format) to Date Format
I have data wehere dates are totally wrong format here is some sample please any one can tel me how to fix in sample data some are dd/mm/yy and some mm/dd/yyyy and so on
i want proper date format (dd/mm/yyyy)
21/5/19 11:28
15/5/19 15:07
4/2/2020 7:55
21/5/19 12:02
7/22/19 16:42
15/5/19 11:55
15/5/19 14:14
15/5/19 14:28
15/5/19 14:54
15/5/19 15:00
25/5/19 13:36
4/2/2020 10:27
4/2/2020 8:19
4/2/2020 8:27
23/7/19 9:36
4/2/2020 8:37
16/5/19 14:28
16/5/19 14:35
4/2/2020 12:07
4/2/2020 8:50
4/2/2020 9:00
16/5/19 8:45
16/5/19 10:06
20/6/19 13:23
16/5/19 14:18
16/5/19 14:25
5/22/19 10:55
18/5/19 22:27
4/2/2020 10:19
05/19/19 3:11
5/19/19 18:48
7/23/19 9:36
20/6/19 19:19
4/2/2020 9:11
6 Replies
- Greg_Deckler
Community Champion
SkorpionAAM - So normally in Power Query I do something like this:
- Split on space
- Split on /
- Change type to text for these intermediate columns
- Recombine the columns using & in a new column
- Change to date
- Remove intermediate columns
Happens quite a bit here with people posting dates in European format and I'm in US.
SkorpionAAMi tried that option but still getting error
- amitchandak
Super User
SkorpionAAM , how would decide for the dates where both month and date are below 12
- SkorpionAAM
no there i some abve 12 as well as i said there are diffrent format
- Greg_Deckler
SkorpionAAM If you have mixed mm/dd and dd/mm I don't know how you could determine which is which for all cases unless you have something else in the data that might identify which format it is in, are there any patterns?
