InfoPath Dev

Thanks Hilary... I'll try and let you know.

Ok... Thank you.

In a nutshell, I'm trying to get 23.0007/07/15. Thanks,

Hi Hilary, Thanks for replying. I've created two separate fields; one for date and the other for the sum of all 'Amount' fields in the repeatable table formatting to include the decimals. The concat works fine, but only works when there is actual cents involved, e.g. 23.52; but when there are not cents, e.g. 23.00, it drops ...

I have a repeating table with an 'Amount' field and I have a 'Total' field to sum all amounts. Separate from these, I have another field that I'm trying to concatenate the total sum from the 'Total' field with another date field on the form. This is how I did that: Date field: concat(substring(pay_date, 6, 2), ...