input string not in correct format with date and time ?

The "Input string was not in a correct format" error typically occurs when there is an issue with parsing a string into a DateTime object. In your case, the error is happening when converting the value stored in the Session object to a DateTime object using the Convert.ToDateTime() method.

To solve this error and make your application work on the server, you can follow these steps:

1. Check the value stored in the Session[SessionKeys.VisaExpiryDate] object. Make sure it is a valid DateTime string that can be parsed correctly.

2. Use the DateTime.TryParse() method instead of Convert.ToDateTime() to handle the conversion. This method returns a boolean value indicating whether the conversion was successful or not, without throwing an exception.

3. if (Session[SessionKeys.VisaExpiryDate] == null)
   {
       visaExpiryDate = 0;
   }
   else
   {
       DateTime visDateExpire;
       if (DateTime.TryParse(Session[SessionKeys.VisaExpiryDate].ToString(), out visDateExpire))
       {
           visaExpiryDate = JulianDate.DateTimeToJulian(visDateExpire);
       }
       else
       {
           // Handle the case when the conversion fails
           // You can set a default value or show an error message
       }
   }
   

4. By using DateTime.TryParse(), you can avoid the exception and handle the case when the conversion fails gracefully.

5. Make sure the culture settings on the server are the same as on your local machine. DateTime parsing can be affected by different culture settings, such as date formats and separators. You can set the culture explicitly in your application's configuration or code to ensure consistent behavior.

6. // Set the culture explicitly
   CultureInfo culture = new CultureInfo("en-US");
   Thread.CurrentThread.CurrentCulture = culture;
   Thread.CurrentThread.CurrentUICulture = culture;
   

    

7. By setting the culture explicitly, you can ensure that the DateTime parsing is consistent across different environments.

8. By following these steps, you should be able to solve the "Input string was not in a correct format" error and make your ASP.NET MVC application work correctly on the server.

    

if (Session[SessionKeys.VisaExpiryDate] != null && Session[SessionKeys.VisaExpiryDate] is DateTime)
{
    DateTime visDateExpire = (DateTime)Session[SessionKeys.VisaExpiryDate];

}
    

string dateVisaExpiry = Session[SessionKeys.VisaExpiryDate].ToString();
if (DateTime.TryParseExact(dateVisaExpiry, "yyyy-MM-dd", CultureInfo.InvariantCulture, out DateTime visDateExpire))
{
    visaExpiryDate = JulianDate.DateTimeToJulian(visDateExpire);
}
else
{
    // Handle invalid date format
    visaExpiryDate = 0;
}

Hello Ahmed,

It can be due to different formats based on server and culture. there are two solutions that can help to resolve issue.

Solution 1:

DateTime visDateExpire = DateTime.ParseExact(TxtPolCreatedDate.Text, "dd/MM/yyyy", CultureInfo.InvariantCulture);

Solution 2: Add globalization to web.config

Thanks

Vishal Joshi

Hello,

You are assigning 0 to your datetime field. You should assign date to that field, Your VisaExpiryDate field should be nullable

public DateTime? VisaExpiryDate { get;set; }

if (Session[SessionKeys.VisaExpiryDate] == null)
{
    visaExpiryDate = (DateTime?) null; //Here you need to assign Date field. Due to this its giving error
}
else
{
   DateTime visDateExpire = Convert.ToDateTime(Session[SessionKeys.VisaExpiryDate]);
    visaExpiryDate = JulianDate.DateTimeToJulian(visDateExpire);

}