Browser Forms

Re: Using Xpath to display only the year?

kimospeed — Thu, 24 Jul 2008 09:20:30 GMT

Wow, it works for me as well.

thanks guys.

Re: Using Xpath to display only the year?

jrudolph — Thu, 17 Jul 2008 18:57:09 GMT

Thank you very much. That worked perfectly. I need to spend some time and play with all these different functions.

Re: Using Xpath to display only the year?

RLPopeIII — Thu, 17 Jul 2008 18:54:26 GMT

If your dates are in the InfoPath standard format, you can use the text function substring-before. The date prints out yyyy-mm-dd in a text box. The substring-before function will output all of the text before a certain character. The way to use it:

substring-before(DateField, "-"). DateField is the field that has your date data. The dash let's InfoPath know to stop at the dash and not add the month or day.

Hope this helps,

Ren

Re: Using Xpath to display only the year?

Hilary Stoupa — Thu, 17 Jul 2008 18:48:09 GMT

Hello, and welcome! First change your text box to contain text rather than a date, since we will only have part of the date in there.

Right click your text box and select properties
For Data Type, select Text(string)
Select the formula button next to the Value box in the Default Value section
Select Insert Function
Select substring-before (in the Text functions)
For the first field, put in the field with the date your want or the function today() for today's date
After the comma, put in "-"

Your final formula should look like this (if you are wanting the year for today's date):

substring-before(today(), "-")

Click OK until all dialogs close and open your form in preview to test.

The substring-before function takes all the characters in the first string (today() in our case) up to the first occurance of the character in the second string (the hyphen, for us). Since today() returns a date formatted as: "2008-07-16", taking everything before the first hyphen returns the year.

Let me know if you have trouble with this, okay?

Using Xpath to display only the year?

jrudolph — Thu, 17 Jul 2008 18:27:36 GMT

I am very new to everything XML and InfoPath. I have a need to have a text box which, by default, will automatically displays only the current year, not the full date. I have very limited knowledge of how to use the Xpath feature when setting the default formula. The text box properties are currently to: Data type: Date.

I hope this makes since, any help would greatly be appreciated.