In this tutorial, I'll show you how to fix

  • String was not recognized as a valid DateTime 'dd/MM/yyyy'
  • The conversion of a varchar data type to a datetime data type resulted in an out-of-range value.

Open the web.config file, then add the configuration to set the uiculture and culture attributes as shown below.

    <globalization culture="en-US" uiCulture="en"/>    

or you can open Global.asax file then add the Application_BeginRequest as shown below

protected void Application_BeginRequest(Object sender, EventArgs e)
    CultureInfo cultureInfo = (CultureInfo)Thread.CurrentThread.CurrentCulture.Clone();
    cultureInfo.DateTimeFormat.ShortDatePattern = "dd/MM/yyyy";
    cultureInfo.DateTimeFormat.DateSeparator = "/";
    Thread.CurrentThread.CurrentCulture = cultureInfo;

We will clone the current culture, then modify our culture. The CultureInfo class provides information about a specific culture. It includes the names for the culture, the writing system, the calendar used, the sort order of strings and formatting for dates and numbers.