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.