Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

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

Solved
Jump to Solution
1033 2
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.