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

Popular posts from this blog

javascript - how to protect a flash video from refresh? -

android - Associate same looper with different threads -

visual studio 2010 - Connect to informix database windows form application -