How to remove added time when importing data

[Takodachi]

Hi, I don't know if I'm the only one who encountered this or if anybody has any solution to this.

I have my data in an Excel file and when I try to import it, the dates in one of my fields has inconsistent values with added time. Something like this 01/01/ 2023 12:00:00.

I want to know if there is a way to remove the time at the end. It doesn't make sense when I only have the date inside my data and no time.

If anyone is wondering, the datatype inside my table is Text(255).

Any help would be appreciated.

[Kronos]

Hello @Takodachi,

I also experienced the same problem before, but I found out that it has something to do with Excel's data format. When a date is typed in, it sometimes converts it to a date format instead of just a regular text format. So when importing it to the table, it follows the cell format of the data instead of what we are seeing on our datasheet, that's the reason why there is an added time.

 

I have this workaround to convert it to text before importing it to my table. Here are the steps that I did:

1. Select the column to be converted
   
2. Go to Data Tab and click Text to Columns.
    
3. Choose Delimited for the Original data type. Then Next.
   
4. Uncheck any Delimiters. Then Next.
   
5. Select Text as Column data format. Then Finish.
   
6. Save, then import to the table.

I hope this helps!

 

[Takodachi]

You're a lifesaver, this is what I was exactly looking for!

Thank you @Kronos

[Kronos]

I'm also going to add this link just in case it can also help you out with importing data.

Importing Data

[Kronos]

As well as this article about DataTypes.

I hope this proves useful to you.

Cheers!