Adding specific dates to columns and setting format to YYYYMMDD

[GSCPM]

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 🙂

[tackytechtom · Accepted solution]

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/

[GSCPM]

Thank you so much, so easy when you know how 😉

Much appreciated