Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Date Not Recognized as date in Access

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

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 52

Expert Comment

by:Gustav Brock
ID: 34907022
You are welcome!

/gustav
0

Featured Post

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

Question has a verified solution.

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

If you need a simple but flexible process for maintaining an audit trail of who created, edited, or deleted data from a table, or multiple tables, and you can do all of your work from within a form, this simple Audit Log will work for you.
Windows Explorer let you handle zip folders nearly as any other folder: Copy, move, change, and delete, etc. In VBA you can also handle normal files and folders, but zip folders takes a little more - and that you'll find here.
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

972 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