InfoPath Dev

Thanks for all your help. I ended up getting this to work: concat(substring(NAME, 1, 1), substring(substring-after(NAME, " "), 1, 1), number(substring(DATE, 3, 1)), number(substring(DATE, 4, 1)), number(substring(DATE, 6, 2)), number(substring(DATE, 9, 2)), concat(substring(now(), 12, 2), substring(now(), 15, 2)))  And this is ...

Solution so far: concat(number(substring(DATE, 3, 1)), number(substring(DATE, 4, 1)), number(substring(DATE, 6, 2)), number(substring(DATE, 9, 2)), concat(substring(now(), 12, 2), substring(now(), 15, 2)))  That is returning the date (from a date picker) and the time(now) as YYMMDDHHMM The names are formated as "firstname ...

Alright, I worked out a little bit of it myself: This is date in YYMMDD format: concat(number(substring(DATE, 3, 1)), number(substring(DATE, 4, 1)), number(substring(DATE, 6, 2)), number(substring(DATE, 9, 2))) But it will only work if the date comes from a date picker (called DATE in this case)   So I please need help on the TIME (now) ...

I have been trying to construct a formula that take the initials of a persons name (from the 'name' field) and the DATE expressed as YYMMDD and the TIME expressed as HHMM. And concatenated it looks like ABYYMMDDHHMM I keep ending up with a complete dog's breakfast of either errors or '12-2812:33' or '198,456,44' and ...