Error in date column - Unable to change type

[Rotemshan]

Hello, 

I'm experiencing some issues with a date column, 

I have reviewed some of the suggestions in the forum, but unfortunately, none of the solutions worked. 

I'm working with data that was imported from a CSV file (Not sure how important this detail is).

One line is empty in the column 

The data type is "text" by default but, when trying to change it to a date, or change it by locale, all become to be "errors"

I tried to:

1. Split the column to date and time
2. Replace the blank values with null/blank

Nothing seems to be working

Any Ideas to fix it? 

Before

After

[amitchandak]

@Rotemshan , Create a new column using Date>FromText([Column]) 

https://docs.microsoft.com/en-us/powerquery-m/date-fromtext

if required do clean and trim

Power Query Trim and Clean : https://youtu.be/NRYPsCnS0w4

[Rotemshan]

I'm sorry - I'm a newbie, 

Could you please be more detailed 

I tried to google your answer and couldn't understand what steps should be taken 

[Rotemshan · Accepted solution]

I changed the source of the data to be XLSX instead of SCV, 

It saves a lot of time converting the data