Forum Discussion

Companyuser101's avatar
3 years ago

Date from text after underscore

Hello,

 

in power query this is my source name: 

 

the 2022106 in the text is my date: 6.10.2022

 

How can I extract this in power query to form a date? 

 

Thanks in advance!