InfoPath Dev

If the actual value of the string is M/d/yyyy (not just the formatting - XML dates are always yyyy-MM-dd), you can combine a couple of substring-after... substring-after(datefield, "/") gets you d/yyyy so: substring-after(substring-after(datefield, "/"), "/") should get you just the year I think.

Hi Everyone I've been developing infopath forms for a couple of years but a recent user of qrules.  I have a need to calculate either the week number or the beginning (Monday) and ending (Friday) dates of the week for a value selected in date picker.  I have seen posts that say this can be done with qrules but I'm not sure ...

 so just before I play your date format is d/mm/yyyy or dd/mm/yyyy i.e. 30/01/2013 if January or 30/1o/2013 if October. substring(now(), 0, 5) works if your date is based on now(). Also just tested if your original date field is a date control it seems to work too. Check your original date control too. I've seen this ...

Thanks for your response, unfortunately it does not work, as it is starting at beginning of string and I need to grab the last 4 digits (2013), so start at the end and move backward 4; and the date is a field populating during rendering.

How does substring(Date, 0, 5) work for you?

In Sharepoint I have a list created. In the list I have times in a drop-down list using this fomat: 8:30 AM I have seen posts without the AM/PM specification; however, I really want to use it. I use this calculation and it works beautifully in the Sharepoint list to calculate the amount of time between two times.  Where Sun1Out = Stop Time ...

 If I remember this correctly the form template has to be put in full Trust on SharePoint in the settings and the web service had to be cross domain.

 Hello Experts,                    Is there a way to fetch User profile info on InfoPath web forms?? I know that using GetUserProfileByName Webservice, we can fetch loggedin user details on the Client Based Infopath forms. I want the same feature on Web ...

Hilary,  Attached the screenshot I am trying to save the TimeStamp when ever the filled out infopath form is edited and saved in the browser. Currently, i have done it through a text field appending the field value each time the data is saved. I have used a formula for the text field bound value. But the formatting is not ...

Hi, I am looking for an expression I can use in xpath that works similar to the function 'Right', which starts at the far right of a string and then moves to the left a designated number of spaces. What I am trying to do is dispay just the year of a completion date. But substring(Date,6,4) did not work for me because the datetype is ...