Designer - Advanced Condition using XPATH
I have the following XPATH expression and I need help subtracting 2 years and 6 months off of the Current Date ($Today):
ddwrt:DateTimeTick(ddwrt:GenDisplayName(string($thisNode/@Modified))) <= ddwrt:DateTimeTick(ddwrt:GenDisplayName(string($Today)))
Any links to good sources of reading for XPATH and SharePoint would be appreciated as well.
February 2nd, 2012 2:39pm
Hi xtreme9,
In XPath expression, there is function called subtract-yearMonthDuration-from-dateTime. The following code is simple. "P2Y6M" is means 2years and 6 months.
subtract-yearMonthDuration-from-dateTime(xs:dateTime("2000-10-30T11:12:00"), xs:yearMonthDuration("P2Y6M"))
More XPath expression
please refer to the following link.
http://www.w3.org/TR/xpath-functions/#func-add-dayTimeDuration-to-dateTime
Thanks,
Jack
Free Windows Admin Tool Kit Click here and download it now
February 5th, 2012 10:56pm
Hi xtreme9,
In XPath expression, there is function called subtract-yearMonthDuration-from-dateTime. The following code is simple. "P2Y6M" is means 2years and 6 months.
subtract-yearMonthDuration-from-dateTime(xs:dateTime("2000-10-30T11:12:00"), xs:yearMonthDuration("P2Y6M"))
More XPath expression
please refer to the following link.
http://www.w3.org/TR/xpath-functions/#func-add-dayTimeDuration-to-dateTime
Thanks,
Jack
February 6th, 2012 6:53am
Hi xtreme9,
In XPath expression, there is function called subtract-yearMonthDuration-from-dateTime. The following code is simple. "P2Y6M" is means 2years and 6 months.
subtract-yearMonthDuration-from-dateTime(xs:dateTime("2000-10-30T11:12:00"), xs:yearMonthDuration("P2Y6M"))
More XPath expression
please refer to the following link.
http://www.w3.org/TR/xpath-functions/#func-add-dayTimeDuration-to-dateTime
Thanks,
Jack
Free Windows Admin Tool Kit Click here and download it now
February 6th, 2012 6:53am