Help

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

Solved
Jump to Solution
301 0
cancel
Showing results for 
Search instead for 
Did you mean: 
jaymees
4 - Data Explorer
4 - Data Explorer

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

jaymees_2-1708335245151.png

 

jaymees_0-1708335124579.png

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

jaymees_1-1708335204122.png

This is the original data after importing from Excel sheet. 

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

 

 

1 Solution

Accepted Solutions
TheTimeSavingCo
18 - Pluto
18 - Pluto

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:

Screen Recording 2024-02-20 at 7.22.29 AM.gif

Link to base

See Solution in Thread

2 Replies 2
TheTimeSavingCo
18 - Pluto
18 - Pluto

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:

Screen Recording 2024-02-20 at 7.22.29 AM.gif

Link to base

jaymees
4 - Data Explorer
4 - Data Explorer

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.