?
Solved

Date Not Recognized as date in Access

Posted on 2011-02-16
3
Medium Priority
?
299 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 53

Accepted Solution

by:
Gustav Brock earned 2000 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 53

Expert Comment

by:Gustav Brock
ID: 34907022
You are welcome!

/gustav
0

Featured Post

Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Beware when using the ListIndex and the Column() properties of a listbox in Access 2007.  A bug has been identified in the Access 2007 listbox code which can cause the .ListIndex property to return a -1, and the .Columns(#) property to return a NULL…
When we develop an application in Ms Access 2016 we should also try to protect the queries, macros and table links. I know I may not have a permanent solution but for novice users, they will not manage to break your application. Below is the detail …
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.
How can you see what you are working on when you want to see it while you to save a copy? Add a "Save As" icon to the Quick Access Toolbar, or QAT. That way, when you save a copy of a query, form, report, or other object you are modifying, you…

589 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