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

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics