Help formatting an expression field...

[Andrea L]

Hi,

I have an expression field on my form that simply has now() in it to show
the date and time of when the form is filled out. I would like to format this
field so that it just shows all numbers like this mmddyyhhmmss with no
symbols between. Is there any way to change the formatting of a field like
that?

thanks,
Andrea

 

[S.Y.M. Wong-A-Ton]

Yes, use the substring() and concat() functions on the now() function.

To understand how dates are represented in InfoPath behind the scene, take a
look at this article:
http://enterprise-solutions.swits.net/infopath/date-time-basics-infopath.htm

And check out this one
http://enterprise-solutions.swits.net/infopath/auto-format-time-on-lostfocus.htm for an example on how to use substring() and concat().