InfoPath Dev

 All,

Currently attempting to output rows of data from a repeating table to one long line.

My repeating table has the columns date/hours/other 

 My current formula is substring(eval(eval(Date[Hours > 0], 'concat(";", .)'), ".."), 2)

This outputs the date of each row only.

No matter, how I concatenate I can't seem to get the date and the corresponding hours.

Any ideas?

W 

 One Step closer.

I've now changed my formula as follows:

substring(eval(eval(Date[Hours > 0] | Hours[. > 0] | FullPartTime[Hours > 0], 'concat(";", .)'), ".."), 2)

Output is 2016-05-09T00:00:00;AM;7;2016-05-10T00:00:00;PM;7  

This at least gives me all my columns and data. I'm sure it can be done cleaner.

AM/PM is not always going to be present

Next step is  to take 2016-05-09T00:00:00;AM;7;2016-05-10T00:00:00;PM;7   and turn it into 2016-05-09 7 AM : 2016-05-09 7 PM