Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Date Not Recognized as date in Access

Posted on 2011-02-16
3
Medium Priority
?
290 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
[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
3 Comments
 
LVL 51

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 51

Expert Comment

by:Gustav Brock
ID: 34907022
You are welcome!

/gustav
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

As tax season makes its return, so does the increase in cyber crime and tax refund phishing that comes with it
Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

670 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