How to extract this text to a date in a column

[Fools_Gold]

Hello,

I cant seem to convert this to a date. The column goes something like below:

"ForecastSnap2024-07-01 00:00:00"

"ForecastSnap2024-08-01 00:00:00"

"Sales"

"ForecastSnap2024-09-01 00:00:00"

"Sales"

"ForecastSnap2024-10-01 00:00:00"

What I want:

2024-07-01

2024-08-01

"" - Sales should be blank

2024-09-01

"" - Sales should be blank

2024-10-01

Then I want convert it to a date, excluding the blank ones.

Thanks,

Fools_Gold

[Gabry · Accepted solution]

Hello,

does it always starts with the string "Forecastsnap"? If yes, it's easy, add a personalyzed column 

if Text.StartsWith([ColumnName], "ForecastSnap") then Text.Middle([ColumnName], 12, 10) else null

[Fools_Gold]

It worked! Thank you!

[Gabry]

😉