I have a .NET user control that filters out data based on a date, this worked fine on my hosting but I wanted to develop extra things locally so packaged up everything and installed it locally. My hosting is US date settings, I have UK date settings but have tried changing this to US and I still get this error.
The line of code that errors is:
dv.RowFilter = "[Hide in Navigation] = 0 AND " + String.Format(System.Globalization.CultureInfo.InvariantCulture.DateTimeFormat, "[Date] > #{0}#", DateTime.Today.ToString());
String was not recognized as a valid DateTime
I have a .NET user control that filters out data based on a date, this worked fine on my hosting but I wanted to develop extra things locally so packaged up everything and installed it locally. My hosting is US date settings, I have UK date settings but have tried changing this to US and I still get this error.
The line of code that errors is:
dv.RowFilter = "[Hide in Navigation] = 0 AND " + String.Format(System.Globalization.CultureInfo.InvariantCulture.DateTimeFormat, "[Date] > #{0}#", DateTime.Today.ToString());
is working on a reply...