General

Re: Equivalent expression in xpath for 'Right' used in Excel?

Laura — Fri, 08 Nov 2013 17:47:50 GMT

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

Re: Equivalent expression in xpath for 'Right' used in Excel?

Laura — Fri, 08 Nov 2013 17:46:30 GMT

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.

Re: Equivalent expression in xpath for 'Right' used in Excel?

Hilary Stoupa — Fri, 08 Nov 2013 17:01:15 GMT

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.

Re: Equivalent expression in xpath for 'Right' used in Excel?

wilkies0106aw — Fri, 08 Nov 2013 16:43:35 GMT

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

Re: Equivalent expression in xpath for 'Right' used in Excel?

Laura — Fri, 08 Nov 2013 16:38:54 GMT

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.

Re: Equivalent expression in xpath for 'Right' used in Excel?

wilkies0106aw — Fri, 08 Nov 2013 16:14:05 GMT

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

Equivalent expression in xpath for 'Right' used in Excel?

Laura — Thu, 07 Nov 2013 21:57:47 GMT

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.