asked on 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?
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?
Microsoft AccessMicrosoft SharePoint
Last Comment
crystal (strive4peace) - Microsoft MVP, Access
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Yes I am Crystal and Gustav that does not work and is what I was using.
ASKER
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.
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
> "EXCEPT for the 1/1/1901 date"
perhaps that record did not have a date and that got put there by the system