Updating a linked Table field from Short Text to Date (1 Viewer)

marseneault

Registered User.
Local time
Today, 08:56
Joined
Jan 11, 2019
Messages
24
Hello,
I am having issues with a linked table (in excel) not formating a date field as a date field.

I have an online program that outputs all the information in One Excel Spreadsheet with Tabs. That Spreadsheet is linked to it's corresponding table in my database.
Most of the Date Types are what they need to be, however, i have one date field that comes in as Short Text, instead of date/Time. this just happens to be a field where I need to run a search query by selecting a date range for the past 7 days.

What can I do to update this field to the proper Data Type?
 

theDBguy

I’m here to help
Staff member
Local time
Today, 05:56
Joined
Oct 29, 2018
Messages
21,357
If you look at the Excel sheet, are there any empty rows towards the top of the problem column?
 

gemma-the-husky

Super Moderator
Staff member
Local time
Today, 12:56
Joined
Sep 12, 2006
Messages
15,613
you could create a template table, and read the data into that table. If that fails, then import the data as at present, add another date field, and update the new field with the converted dates.

As TheDBGuy says, it's maybe worth inspecting the spreadsheet to understand what's going on. If dates in the table are badly formed, it will import as text
 

Users who are viewing this thread

Top Bottom