Convert a date without slashes into a Date column|Power Query|Excel Forum|My Online Training Hub

Hi Raza,

I can only use 14092019 as an example,  please see attached,   you will need to use Transform > Split Column,   first split number of characters =4  then split further 1409 into 14 & 09,   then use custom column 

[Date.1.1]&"/"&[Date.1.2]&"/"&[Date.2]    to achieve the date format that you want,  take note that in the end need to change type to date

This is assumed that whole column are with DDMMYYYY format then you can use the applied steps to convert all,  however if there is date-liked type 1082019,   it can be  DDMYYYY  or DMMYYYY,   so this is consider dirty entries as you won't know exactly what the input guy date format

if the column is a date column is in  20/09/2019  for e.g.  and you want to convert to "MMM-yyyy“   （M must be Upper case,  D and Y lower case),  you can use

Date.ToText([Date], "MMM-yyyy")

if you need my help further,  kindly upload a sample dataset and I can work on it