I am trying to submit the contents of a repeating table in an InfoPath form to a new SharePoint list.  Everything works well until I try and manipulate one of the date fields.
I have a Date Picker “DateEnd” with a data type of text and a format of dd/mm/yyyy.  
If I pass the date as shown below everything is fine
 
Dim PickEnd As String = rows.Current.SelectSingleNode("my:PickEnd", NamespaceManager).Value
However what I need to do is add 24 hours to the time.  So as a test I have tried all of the following options.
'**NO RESULT 1
Dim PickEnd As Date = rows.Current.SelectSingleNode("my:PickEnd", NamespaceManager).Value
 
'**NO RESULT 2
Dim x As Date = CType(rows.Current.SelectSingleNode("my:PickEnd", NamespaceManager).Value, Date)
Dim PickEnd As String = x
 
'**NO RESULT 3
Dim PickEnd As String = CType(rows.Current.SelectSingleNode("my:PickEnd", NamespaceManager).Value, Date)
 
 
'**NO RESULT 4
Dim Workdate As Date
Workdate = rows.Current.SelectSingleNode("my:PickEnd", NamespaceManager).Value
Workdate = Workdate.AddSeconds(1)
PickEnd = Workdate.ToString
 
In saying “NO RESULT”, I get no data in my new list.  How can I manipulate the date prior to sending it to the list?  The “PickEnd” field in the new list is defined as Date/Time.