Question: I have shifted our live server to a new server configuration Windows 2008 server and sql server 2008.

But I am having following exception while adding date field data :

> 
> 2011-05-15 18:00:44,263 ERROR Error
>  caught : the details of the error are 
>  System.Data.SqlTypes.SqlTypeException:
>  SqlDateTime overflow. Must be between
>  1/1/1753 12:00:00 AM and 12/31/9999
>  11:59:59 PM. at
>  System.Data.SqlTypes.SqlDateTime.FromTimeSpan(TimeSpan
>  value)
> 
> 
> 

But the same code is working fine on local machine and was also working fine on old server.

I have even changed the date field explicitly into **"mm/dd/yy"** format.
But still not found the solution.
Can anyone provide me the solution.

Answer: 
There's actually three things: A Website, a Store and a Store View.

The most important part about Websites is that each websites has its unique customer and order base.

Stores can be used to define for example different (looking) stores with the same information.

Store Views are mostly used to handle different languages on your website. You will typically have one Store View per language.
Here is what I found on Magento site which helped me to clear the difference between the 3 notions. 

**Website** is a parent of store (or a basis for a store). It can consist of one or several stores. 

**Store** is a "child of website". You create and manage products and categories on this level. 
Store (or store view group): Stores are ‘children’ of websites. Products and Categories are managed on the store level. A root category is configured for each store. 

To be browsable in the interface a store requires one or more **store views**. The catalog structure per store view will always be the same. It allows multiple store presentations in the front end (like the opportunity to switch between 2 or more languages)