Help formatting an expression field...

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Andrea L - 16 May 2006 21:45 GMT

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

Reply to this Message

S.Y.M. Wong-A-Ton - 13 Jun 2006 22:09 GMT

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().
---
S.Y.M. Wong-A-Ton

> Hi,
>
[quoted text clipped - 6 lines]
> thanks,
> Andrea

Reply to this Message