Date Format In Table

[MFS]

Not sure if I am posting in the correct forum for this question.

I use SQL tables within my Access DB, In the tables my date field is automatically updated whenever data is entered. The issue is the format of the date is YYYY-MM-DD, this presents a small problem to the DB user when Querying the data for here in the states we are used to a MM/DD/YYYY format.


Searching the net I could not find a way to reformat the date within the SQL table. If someone could guide me in the right direction in doing so that would be great, otherwise is there a way that we could work around this in Access ?
Open to suggestions . . .

[isladogs]

SQL Server dates are always shown as YYYY-MM-DD but they are stored as double datatype numbers (same as in Access)
Access will display those dates in the default Windows format e.g. mm/dd/yyyy unless you tell it otherwise
So you should need to do nothing - your query should just work.

Check the following
a) default date format in Windows settings
b) date formatting for that field in the table & the form

If you can't find where its being set, try using Format(MyDateField,"mm/dd/yyyy") but be aware this converts it into a string

[MFS]

Thank You ridders52, Well now I feel like a total idiot, I should have checked my Query with the MM/DD/YYYY format but just didn't for I truly thought that it would not work. I have checked now and it does work.
Thank You again

[isladogs]

No problem