<div>
Yes I am Crystal and Gustav that does not work and is what I was using.
</div>


Yes I am Crystal and Gustav that does not work and is what I was using.

<div>
So I thought I was on to something and made a table from the query. &nbsp;The data in the date field looks like any other date field. (no time). &nbsp;the date as it came over is 1/1/1901. &nbsp;I can filter by any other date just like always using an Access query EXCEPT for the 1/1/1901 date.
</div>


So I thought I was on to something and made a table from the query.  The data in the date field looks like any other date field. (no time).  the date as it came over is 1/1/1901.  I can filter by any other date just like always using an Access query EXCEPT for the 1/1/1901 date.

<div>
in the underlying table, what is the data type of that field? Date? Date and Time? ... ?<br />
<br />
&gt;&nbsp;&quot;EXCEPT for the 1/1/1901 date&quot;<br />
<br />
perhaps that record did not have a date and that got put there by the system
</div>


in the underlying table, what is the data type of that field? Date? Date and Time? ... ?

> "EXCEPT for the 1/1/1901 date"

perhaps that record did not have a date and that got put there by the system

<div>
<div class="content wysiwyg-content">
Hello,<br />
<br />
I have a Sharepoint list with dates and I want to filter out the dates of 01/01/1901 using MS Access 2013. if I enter as #01/01/1901# it has no effect at all. &nbsp;how do I either select or &quot;Not select&quot; this date?
</div>
</div>


Hello,

I have a Sharepoint list with dates and I want to filter out the dates of 01/01/1901 using MS Access 2013. if I enter as #01/01/1901# it has no effect at all.  how do I either select or "Not select" this date?

query 01/01/1901 in a Sharepoint list

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Microsoft Access

Microsoft Sharepoint is a software platform and family of software products used for collaboration and web publishing combined. These capabilities include developing web sites, portals, intranets, content management systems, search engines, wikis, blogs, and other tools for business intelligence and collaboration. SharePoint has a Microsoft Office-like interface, and it is closely integrated with the Office suite.