query 01/01/1901 in a Sharepoint list

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?
vmccuneAsked:
Who is Participating?
 
crystal (strive4peace) - Microsoft MVP, AccessConnect With a Mentor Remote Training and ProgrammingCommented:
are you linking to a Sharepoint  list from Access?
0
 
Gustav BrockConnect With a Mentor CIOCommented:
Don't know what "as" means here.

To filter on (or for), use:

    #01/01/1901#

To filter out, use:

    <>#01/01/1901#

as criteria for the date field in your query.

/gustav
0
 
vmccuneAuthor Commented:
Yes I am Crystal and Gustav that does not work and is what I was using.
0
 
vmccuneAuthor Commented:
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.
0
 
crystal (strive4peace) - Microsoft MVP, AccessRemote Training and ProgrammingCommented:
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
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.