?
Solved

query 01/01/1901 in a Sharepoint list

Posted on 2016-09-07
5
Medium Priority
?
110 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
5 Comments
 
LVL 22

Accepted Solution

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

Assisted Solution

by:Gustav Brock
Gustav Brock earned 1000 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 22
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

Enroll in August's Course of the Month

August's CompTIA IT Fundamentals course includes 19 hours of basic computer principle modules and prepares you for the certification exam. It's free for Premium Members, Team Accounts, and Qualified Experts!

Question has a verified solution.

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

Traditionally, the method to display pictures in Access forms and reports is to first download them from URLs to a folder, record the path in a table and then let the form or report pull the pictures from that folder. But why not let Windows retr…
This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …
Suggested Courses

770 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