Code:

<!-- Web.Config Configuration File -->

<configuration>
	<system.web>
		<compilation defaultLanguage="VB" debug="false" />
		<pages validateRequest="false" />
		<globalization 
	            culture="en-US" 
        	    uiCulture="en-US" 
		/>
	</system.web>
	<appSettings>
		<add key="DatabaseString" value="..." />
		<add key="DatabasePrefix" value="DMG" />
	</appSettings>
</configuration>

Quote:

Quoted From grimmeissen:

This is a very common issue that has been answered many times. If you are having issues with your SQL Server date format not matching up with your web site's date format, you will need to modify your web.config file to change the format to whatever the database expects.

For a Microsoft.com article that explains how to modify the web.config file to specify your regional settings, click the link below.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpgenref/html/gngrfglobalizationsection.asp

As an example, the following web.config file would set your application to use the United States English date format.



The link below leads to another Microsoft article that lists all of the available regional codes that can be placed in the globalization tag of your web.config. Use this to determine which code will match the date format of your database.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpref/html/frlrfSystemGlobalizationCultureInfoClassTopic.asp