Why can't I convert text to date when importing excel sheet?

[jaymees]

Hi,

Every time I try to convert the multiple select field (automatic field from import) to Date (with time included), I get this message that some cell data may be cleared. And indeed, most of the cell data were cleared. I don't understand this as my data is clean it is a standard 03/05/2023 7:00:00, 10/05/2023 7:00:00, 17/05/2023 7:00:00, etc

As you can see, the three rows show up blank after I try to convert to Date (with time) field.

This is the original data after importing from Excel sheet. 

Would appreciate any advise on how I could convert all data successfully. Thanks!

[TheTimeSavingCo · Accepted solution]

I think it might be due to the format of the date you're converting it to.  Your dates are set as European format (DD/MM/YYYY), and so once you select that format when you're converting the field it should work:

Link to base

[jaymees]

AMAZING!! Thank you so much for your advise, Adam @TheTimeSavingCo! I was so bent on using the Friendly date format that I completely overlooked the European time format. I was able to change it to Friendly date format after first converting it to European format as you advised.