Forum Discussion
Adding specific dates to columns and setting format to YYYYMMDD
Hello, I would like to add 2 specific dates in separate columns in my Power query.
I would like the dates as follows:
1. Start date 20230101 (YYYYMMDD)
2. End date 20300101 (YYYYMMDD)
I have read a lot of the similar questions on here but just cant find an exact solution.
thank you 🙂
Hi GSCPM ,
Maybe the following helps:
Before:
After:
I did this:
Is it this you were looking for? Otherwise, feel free to explain it more or provide sample data 🙂
/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/
2 Replies
Hi GSCPM ,
Maybe the following helps:
Before:
After:
I did this:
Is it this you were looking for? Otherwise, feel free to explain it more or provide sample data 🙂
/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/Thank you so much, so easy when you know how 😉
Much appreciated
