https://www.infopathdev.com:443/forums/39.aspxNew to InfoPath? Search to see if your question has already been answered. If it has not, then ask it here or the appropriate topic forum.enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/117700.aspxWed, 22 Nov 2017 15:26:45 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:117700The Great One0https://www.infopathdev.com:443/forums/thread/117700.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=117700Resolved this with a workaround Year substring(now(), 1, 4) 1st letter return 4 Month substring(now(), 6, 2) 6th letter return 2 Date substring(now(), 9, 2) 9th letter return 2 Hour substring(now(), 12, 2) 12th letter return 2 Minute substring(now(), 15, 2) 15th letter return 2 Second substring(now(), 18, 2) 18th letter return 2https://www.infopathdev.com:443/forums/thread/117695.aspxWed, 22 Nov 2017 07:47:05 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:117695The Great One0https://www.infopathdev.com:443/forums/thread/117695.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=117695I'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?