I have a Microsoft Access Services Database that is stored on it's own Sharepoint Site. One of my tables has a date field that stores the date as 10/01/2008, etc. When I open the table, I can clearly see it in that format.
I then have a query that is linking the date field on that table to another table and date field set up the same way.
The problem is that I have another user that upon opening that first table, sees the field as a date/time format, i.e., 10/01/2008 09:00:00 AM. Because of this, the query doesn't return results for him. He is using the same version of Access.
I can't figure out what settings would be causing him to not be able to view the table in the correct format. Any thoughts?
I then have a query that is linking the date field on that table to another table and date field set up the same way.
The problem is that I have another user that upon opening that first table, sees the field as a date/time format, i.e., 10/01/2008 09:00:00 AM. Because of this, the query doesn't return results for him. He is using the same version of Access.
I can't figure out what settings would be causing him to not be able to view the table in the correct format. Any thoughts?
