I'm using Infopath Designer 2013.
I need to create a unique ID of YYMMDDHHMMSS , with no symbols.
I have used "concat(Request Type, TodayYear(substring(now(), 1, 4)), TodayMonth(substring(now(), 6, 2)), TodayDate(substring(now(), 9, 2)), TodayHour(substring(now(), 12, 5)), TodayMinute, TodaySecond)"
However i cannot get the TodayMinute to display just MM and TodaySecond to display just SS with no symbols i.e. ":".
Can anyone help with this?