Using steps in Power Query we can extract portions of a number and then merge them back together and change the data type to a Date.
Having these extract columns can also prove helpful in other ways when manipulating data.
Cathi Barker Software Solutions