# Attain to MS Access DATE filtering via ODBC

**URL:** <https://www.dynamicsuser.net/t/attain-to-ms-access-date-filtering-via-odbc/14163>\
**Category:** Developers Forum\
**Created:** [March 4, 2002, 1:29pm UTC](https://www.dynamicsuser.net/t/attain-to-ms-access-date-filtering-via-odbc/14163 "2002-03-04T13:29:21Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![FormerMember](https://avatars.discourse-cdn.com/v4/letter/f/74df32/32.png) [@FormerMember](https://www.dynamicsuser.net/u/FormerMember)\
**Post date:** [March 4, 2002, 1:29pm UTC](https://www.dynamicsuser.net/t/attain-to-ms-access-date-filtering-via-odbc/14163/1 "2002-03-04T13:29:21Z")

</div>

Hi, I’m having problems in retrieving data from Attain to MS Access via ODBC when I put some filtering criteria on any date field. The ODBC driver simply doesn’t understand the date filter & returns an error. On the other hand, it works fine with MS Excel. Any one have any ideas, WHY & HOW can I fix this problem?

---

<div class="post-metadata">

**Author:** ![KarlNapp](https://avatars.discourse-cdn.com/v4/letter/k/73ab20/32.png) [@KarlNapp](https://www.dynamicsuser.net/u/KarlNapp)\
**Post date:** [March 7, 2002, 11:46am UTC](https://www.dynamicsuser.net/t/attain-to-ms-access-date-filtering-via-odbc/14163/2 "2002-03-07T11:46:18Z")

</div>

Hi, switch the “Identifiers”-Option in the “C/ODBC Options” to “All Exept Space” Bye KarlNapp

---

<div class="post-metadata">

**Author:** ![FormerMember](https://avatars.discourse-cdn.com/v4/letter/f/74df32/32.png) [@FormerMember](https://www.dynamicsuser.net/u/FormerMember)\
**Post date:** [March 15, 2002, 7:52am UTC](https://www.dynamicsuser.net/t/attain-to-ms-access-date-filtering-via-odbc/14163/3 "2002-03-15T07:52:18Z")

</div>

Thanks Hein, I solved the problem by uncheking “Commit Cache” and “Closing Date Support” in C/ODBC options. Identifiers is still set to “All Except DOT”! Bye Tariq