trouble with dynamic hyperlink

[Joel Allen]

Hello,

I'm trying to create a dynamic hyperlink in infopath. I'm trying to extract
the year out of one of the fields and it is not working. e.g. I think it's
just a syntax problem. Can you please help?

\\Year(StartDate)\etc...... or \\Year(my:StartDate)\etc...... .

Thanks for your help,
Joel

 

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

Not sure if you're trying to do something in code or by using formulas, but
take a look at this article, since it might help:
http://enterprise-solutions.swits.n...hp?t=date-time-basics-infopath&c=infopath2003

Extracting the year would be a matter of parsing the date and not calling
"Year(...)" whatever that might be.

 

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

Sorry, Joel. Just realized you might be trying to use the Year function of
VBScript in an XPath expression. If this is the case, that will not work,
since dates in Infopath are not objects, but just text.

If you are using formulas, look into using the substring() function to
extract the year in a date. If you are using code, try the Mid() function of
VBScript.

Let me know how it goes.

 

[Joel Allen]

Thank you! Substring worked perfect.

Joel

Sorry, Joel. Just realized you might be trying to use the Year function of
VBScript in an XPath expression. If this is the case, that will not work,
since dates in Infopath are not objects, but just text.

If you are using formulas, look into using the substring() function to
extract the year in a date. If you are using code, try the Mid() function
of
VBScript.

Let me know how it goes.

 

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

You're welcome! Glad you got it working now.