Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / General MS InfoPath Questions / October 2006

Tip: Looking for answers? Try searching our database.

trouble with dynamic hyperlink

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Joel Allen - 25 Oct 2006 19:54 GMT
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 - 26 Oct 2006 00:33 GMT
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.net/infopath2003/article.php?t=date-time-basic
s-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

> Hello,
>
[quoted text clipped - 6 lines]
> Thanks for your help,
> Joel
S.Y.M. Wong-A-Ton - 26 Oct 2006 08:38 GMT
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

> Hello,
>
[quoted text clipped - 6 lines]
> Thanks for your help,
> Joel
Joel Allen - 26 Oct 2006 18:16 GMT
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,
[quoted text clipped - 21 lines]
>> Thanks for your help,
>> Joel
S.Y.M. Wong-A-Ton - 27 Oct 2006 07:56 GMT
You're welcome! Glad you got it working now.
---
S.Y.M. Wong-A-Ton

> Thank you!  Substring worked perfect.
>
[quoted text clipped - 25 lines]
> >> Thanks for your help,
> >> Joel
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.