Display just DD (Date) and SS (Seconds) in Infopath form - InfoPath Dev
in

InfoPath Dev

Display just DD (Date) and SS (Seconds) in Infopath form

Last post 11-22-2017 07:26 AM by The Great One. 1 replies.
Page 1 of 1 (2 items)
Sort Posts: Previous Next
  • 11-21-2017 11:47 PM

    Display just DD (Date) and SS (Seconds) in Infopath form

    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?
  • 11-22-2017 07:26 AM In reply to

    Re: Display just DD (Date) and SS (Seconds) in Infopath form

    Resolved 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 2
Page 1 of 1 (2 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.