Jump to content
  • 0

How to remove added time when importing data



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.

Link to comment
Share on other sites

4 answers to this question

Recommended Posts

  • 1

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!


Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...