Power Query Basic 11 - Convert Date Text into Date

In Power Query Basic 03, I introduced basic data types in Power Query. In this video, you will see a deeper demo to a commonly used data type - Date.
Indeed it is very common to deal with date stored as text in different formats. It could be challenging to convert those text dates into real dates that Excel recognizes and work with for further analysis. This task is, unbelievably, super easy in Power Query. You will see how in this short video.
You may download a sample file from my blogpost to follow along.
wmfexcel.com/2...
I hope you like this video. If you do, please give a thumb up, comment, and subscribe my channel. 😉
#excel
#powerquery

[@ZainabJaved-xk9ok]

I am new to power BI and power query. No experience at all. And such simple and direct videos are such a blessing. Thank you so much!!!

[@wmfexcel]

You are welcome! Glad to hear that it helped. Power Query is simply amazing.

[@NehaSingh-of1yw]

This helped me so so much !!!! thanks a lot it was the most usefull tutorial that actually worked ! Lots of love and huge respect ❤❤

[@wmfexcel]

You are welcome! Glad it helped!

[@ntruesingh8517]

Hats off sir, thanks a lot ...liked subscribed as it help solved my headache of hours

[@wmfexcel]

Welcome 👍
Glad it helped!

[@gospelmoto2833]

Wow! that was awesome. I learned something new today. Thanks.

[@wmfexcel]

Glad to hear it!

[@baochinhnguyen3221]

Damn, i was struggling with this error for long time ago, and now, it's gone! thank you so much!

[@wmfexcel]

You are welcome! Glad it helped!

[@vitthaldaskamat1920]

Thank you. Very useful.

[@wmfexcel]

You are welcome!

[@Jay_foryou]

It works. Thanks a lot

[@wmfexcel]

Welcome 👍

[@billalhossainsiam5587]

This video is so helpful. Thanks a lot.

[@wmfexcel]

Glad that you find it helpful!

[@Роман-р7м9ф]

That's was great. Such an easy solution for column yyyymmdd and 30 minutes "google" before your video =)) thanks!

[@wmfexcel]

You are welcome! Glad it helped!

[@Aust1n..]

Thanks

[@wmfexcel]

You are welcome

[@paiinlove1992]

Thank you very much

[@wmfexcel]

You are welcome

[@winny476]

Thank you was looking for this

[@wmfexcel]

You're welcome 😊

[@reetakisna]

Dear sir nice thanks

[@mandarshastri158]

thanks issue solved....😴

[@wmfexcel]

You are welcome!

[@shumanevela9598]

I got the last data that you don’t know how to solve😢

[@wmfexcel]

No worries. That’s doable with extra steps. You can try converting the 8 digit numbers into date string of MM/DD/YYYY first. Not sure how? Try the add column by examples. When you have the conversion done, then you can set the new into proper date easily.