infopath2010 - InfoPath 2010 changing Date/Time/second Formula -
i have formula in textbox generate date, time, , seconds. want format date mm/dd/yyyy instead of yyyy/mm/dd
translate(now(), "_-:t", "")
use functions concat, substring, translate
concat(substring(translate(now(), "_-:t", ""), 5, 2), "/", substring(translate(now(), "_-:t", ""), 7, 2), "/", substring(translate(now(), "_-:t", ""), 1, 4))
output: 09/12/2014
Comments
Post a Comment