Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 151
  • Last Modified:

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?
0
vmccune
Asked:
vmccune
  • 2
  • 2
2 Solutions
 
crystal (strive4peace) - Microsoft MVP, AccessRemote Training and ProgrammingCommented:
are you linking to a Sharepoint  list from Access?
0
 
Gustav BrockCIOCommented:
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

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now