marseneault
Registered User.
- Local time
- Today, 04:20
- 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?
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?