Solved

query 01/01/1901 in a Sharepoint list

Posted on 2016-09-07
5
81 Views
Last Modified: 2016-09-08
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
Comment
Question by:vmccune
  • 2
  • 2
5 Comments
 
LVL 19

Accepted Solution

by:
crystal (strive4peace) - Microsoft MVP, Access earned 250 total points
ID: 41788957
are you linking to a Sharepoint  list from Access?
0
 
LVL 49

Assisted Solution

by:Gustav Brock
Gustav Brock earned 250 total points
ID: 41789159
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
 

Author Comment

by:vmccune
ID: 41789986
Yes I am Crystal and Gustav that does not work and is what I was using.
0
 

Author Comment

by:vmccune
ID: 41789996
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
 
LVL 19
ID: 41790082
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: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

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

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

SharePoint Designer 2010 has tools and commands to do everything that can be done with web parts in the browser, and then some – except uploading a web part straight into a page that is edited in SPD. So, can it be done? Scenario For a recent pr…
I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.

809 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question