InfoPath Dev

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 m/d/yyyy and I cannot change it, so my string is off on certain days.

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

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.

 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 where you set your original date field as a text field and changed it to a date field

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.

i don't have the ability to change my original datetype, due to the datasource, so this does not work for me, but thanks for your help.

Yes, this does work! Thank you. I tried the substring-after, already but did not think to nest two functions.