<div>
I've requested that this question be closed as follows:<br />
<br />
Accepted answer: 250 points for ThomasMcA2's comment <a href="https://www.experts-exchange.com/questions/28632635/Microsoft-Query-Error-Illegal-Data-'-ts-'2015-'-Expected-Format-'Default-Datetime-Mask'.html?anchorAnswerId=40655273#a40655273" rel="ugc">#a40655273</a><br />
Assisted answer: 250 points for chaau's comment <a href="https://www.experts-exchange.com/questions/28632635/Microsoft-Query-Error-Illegal-Data-'-ts-'2015-'-Expected-Format-'Default-Datetime-Mask'.html?anchorAnswerId=40655276#a40655276" rel="ugc">#a40655276</a><br />
<br />
for the following reason:<br />
<br />
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
</div>


I've requested that this question be closed as follows:

Accepted answer: 250 points for ThomasMcA2's comment #a40655273 [https://www.experts-exchange.com/questions/28632635/Microsoft-Query-Error-Illegal-Data-'-ts-'2015-'-Expected-Format-'Default-Datetime-Mask'.html?anchorAnswerId=40655273#a40655273]
Assisted answer: 250 points for chaau's comment #a40655276 [https://www.experts-exchange.com/questions/28632635/Microsoft-Query-Error-Illegal-Data-'-ts-'2015-'-Expected-Format-'Default-Datetime-Mask'.html?anchorAnswerId=40655276#a40655276]

for the following reason:

This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.

<div>
<div class="content wysiwyg-content">
I am creating an ODBC query in Excel 2003 (I know, old). When put in a parameter for a date, I get an error that says: Microsoft Query Error: Illegal Data: '{ts '2015-'. Expected Format: 'Default Datetime Mask' . When I look at the data without parameters, the date is in this format: YYYY-MM-DD. I have tried YYYY-MM-DD, YYYY-MM-DD HH:MM:SS and other variations of YYYY MM DD. Nothing is working. I get the same error every time. Any ideas?
</div>
</div>


I am creating an ODBC query in Excel 2003 (I know, old). When put in a parameter for a date, I get an error that says: Microsoft Query Error: Illegal Data: '{ts '2015-'. Expected Format: 'Default Datetime Mask' . When I look at the data without parameters, the date is in this format: YYYY-MM-DD. I have tried YYYY-MM-DD, YYYY-MM-DD HH:MM:SS and other variations of YYYY MM DD. Nothing is working. I get the same error every time. Any ideas?

Microsoft Query Error: Illegal Data: '{ts '2015-'. Expected Format: 'Default Datetime Mask'

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.

Databases

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.