Converts several date/time formats to standard XML Date/ Time
<pre>
/// <summary>
/// This takes a vendor's non-standard dates, such as 5/1/2008 and formats as XML Date.
/// (i.e. the month may one or two digits, the day may be one or two digits).
/// Neal Walters - changed on 09/03/2008 to throw exception.
/// also tested to make sure it handles all the following dates (and it does)
/// string testDate1 = "03/09/2008";
/// string testDate2 = "1999-05-31";
/// string testDate3 = "03/09/2008 10:50:16.157";
/// string testDate4 = "1999-05-31T13:20:00.000-05:00";
/// string testDate5 = "2008-09-03 10:50:16.157";
/// string testDate6 = "2008-09-32";
/// </summary>
/// <param name="inDate"></param>
/// <returns></returns>
public static string ConvertDateTimetoXmlDateTime(string inDate)
{
try
{
DateTime dtIn = DateTime.Parse(inDate);
return System.Xml.XmlConvert.ToString(dtIn, System.Xml.XmlDateTimeSerializationMode.Local);
}
catch
{
string errorMessage = "invalid-Date/Time-conversion from value='" + inDate + "'";
throw new Exception(errorMessage);
//return errorMessage;
}
}
</pre>