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

c# - HttpResponseMessage System.InvalidOperationException -

sql - Postgresql error: "failed to find conversion function from unknown to text" -