Thread: Date Format v8

Where can I change the date formatt to dd/mm/YYYY ?

I've been looking through the appconfigs/manual with no joy our site is currently showing in an US format.

You would need to change the localization in the web.config (search for 'globalization') and in the database. Your host might have to assist with the second part.

Code:

    <globalization requestEncoding="utf-8" responseEncoding="utf-8" culture="en-US" uiCulture="en-US" />

...would become something like

Code:

    <globalization requestEncoding="utf-8" responseEncoding="utf-8" culture="en-GB" uiCulture="en-GB" />

(or whatever locale you're after)

Thanks Scott, you also mentioned in DB, what needs done there?

You need to set the db to use the same date format as the application using the db. Because you will run into issues when the application tries to apply a datetime or get the datetime from the sql server. So you need to set the locale for the sql server. I think this article (http://support.microsoft.com/kb/173907) is probably what you will need.

I've noticed out SQL is still in US while the rest of our site is GB, will this cause any issues?

Thanks

That's not going to hurt anything really, but your times will be off. The dates/times will all be set on the SQL server.

Thanks for the info