Solved

Date Not Recognized as date in Access

Posted on 2011-02-16
3
232 Views
Last Modified: 2012-06-27
Hi, I have a date field that I believe to be properly fomatted as such.  However, my expressions and conditional statements are ignoring it as a date field.  This was confirmed when I went to add a sort feature to it and it tries to sort "with A on top" rather than by the normal date options when it recognizes it as a date.

Please let me know what I can check.  thanks so much.
0
Comment
Question by:cdarbonne
  • 2
3 Comments
 
LVL 49

Accepted Solution

by:
Gustav Brock earned 500 total points
ID: 34906757
Check the data type of the field. It is Text and should Date.
The format is only for display of the content.

/gustav
0
 

Author Comment

by:cdarbonne
ID: 34906835
Thanks.  Just figured this out.  What it was ....was a linked datasheet from sharepoint pulling in 5 similar lists.  on one of the lists, the date field was set as text.  When I fixed that and refreshed the linked list in access, it worked just fine.

thanks again.
0
 
LVL 49

Expert Comment

by:Gustav Brock
ID: 34907022
You are welcome!

/gustav
0

Featured Post

What Security Threats Are You Missing?

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
MS SQL Bulk load data error 5 34
Error compiling fairly simple database 3 17
Dateadd 3 22
DCount with multiple criteria 3 23
This article is a continuation or rather an extension from Cascading Combos (http://www.experts-exchange.com/A_5949.html) and builds on examples developed in detail there. It should be understandable alone, but I recommend reading the previous artic…
The first two articles in this short series — Using a Criteria Form to Filter Records (http://www.experts-exchange.com/A_6069.html) and Building a Custom Filter (http://www.experts-exchange.com/A_6070.html) — discuss in some detail how a form can be…
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…
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.

744 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now