Thursday, 8 August 2013

Convert XML String to Date

Convert XML String to Date

I have the following piece of code which keeps giving me a strange
exception. (Conversion from string "" to type 'Date' is not valid.)
Me.UpdatedDate = CDate(p_objXML.SelectSingleNode("LastUpdated").Value)
I can only assume it is having trouble parsing the time element of the
String. The value of the XML field is "07/08/2013 16:45:01"
The fields before it and after it work fine, and the field names match up,
correct data type etc. So I am pretty stumped.
Any help would be greatly be appreciated.
Kevin

No comments:

Post a Comment