Was having a devil of a time figuring out how to get the max date out of a node. This post enlightened me to the usage of XSL.<\/p>\n\n\n\n
With XSLT 2.0 it is as easy as taking the min and max e.g.<\/p>\n\n\n
\n<xsl:stylesheet\nxmlns:xsl="http:\/\/www.w3.org\/1999\/XSL\/Transform"\nxmlns:xsd="http:\/\/www.w3.org\/2001\/XMLSchema"\nexclude-result-prefixes="xsd"\nversion="2.0">\n\n<xsl:template match="\/">\n<xsl:variable name="dates" as="xsd:dateTime*"\nselect="dsQueryResponse\/Rows\/Row\/@StartDate\/xsd:dateTime(.)"\/>\n<xsl:text>Minimum date: <\/xsl:text>\n<xsl:value-of select="min($dates)"\/>\n<xsl:text>; maximum date: <\/xsl:text>\n<xsl:value-of select="max($dates)"\/>\n<\/xsl:template>\n\n<\/xsl:stylesheet>\n<\/pre><\/div>\n\n\nYou can run XSLT 2.0 in the COM world (e.g. JScript\/VBScript, VB(A))
with AltovaXML tools http:\/\/www.altova.com\/altovaxml.html<\/a> and in the
.NET world with Saxon 9 (http:\/\/saxon.sourceforge.net\/<\/a>).
Sample dataset:<\/p>\n\n\n\n<dsQueryResponse>\n<Rows>\n<Row ProjectName="Elvis" StartDate="2009-10-01T04:00:00Z"\nTargetDate="2009-12-21T04:00:00Z" Overall_x0020_Status="On Track"\n_x0025__x0020_Complete=".8" \/>\n<Row ProjectName="Dolly" StartDate="2009-09-11T04:00:00Z"\nTargetDate="2009-12-01T04:00:00Z" Overall_x0020_Status="On Track"\n_x0025__x0020_Complete=".66" \/>\n<Row ProjectName="CCR" StartDate="2009-09-21T04:00:00Z"\nTargetDate="2009-11-21T04:00:00Z" Overall_x0020_Status="Manageable\nIssues" _x0025__x0020_Complete=".90" \/>\n<Row ProjectName="Stones" StartDate="2009-09-15T04:00:00Z"\nTargetDate="2009-12-28T04:00:00Z" Overall_x0020_Status="Project\nConcern" _x0025__x0020_Complete=".50" \/>\n<\/Rows>\n<\/dsQueryResponse>\n<\/pre><\/div>","protected":false},"excerpt":{"rendered":"Was having a devil of a time figuring out how to get the max date out of a node. This post enlightened me to the usage of XSL. With XSLT 2.0 it is as easy as taking the min and max e.g. You can run XSLT 2.0 in the COM world (e.g. JScript\/VBScript, VB(A))with AltovaXML […]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_crdt_document":"","jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[22],"tags":[],"class_list":["post-1174","post","type-post","status-publish","format-standard","hentry","category-xsl","author-aron"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/p4bBkH-iW","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/asberry.org\/blog_tech\/index.php?rest_route=\/wp\/v2\/posts\/1174","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/asberry.org\/blog_tech\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/asberry.org\/blog_tech\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/asberry.org\/blog_tech\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/asberry.org\/blog_tech\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1174"}],"version-history":[{"count":2,"href":"https:\/\/asberry.org\/blog_tech\/index.php?rest_route=\/wp\/v2\/posts\/1174\/revisions"}],"predecessor-version":[{"id":1176,"href":"https:\/\/asberry.org\/blog_tech\/index.php?rest_route=\/wp\/v2\/posts\/1174\/revisions\/1176"}],"wp:attachment":[{"href":"https:\/\/asberry.org\/blog_tech\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1174"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/asberry.org\/blog_tech\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1174"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/asberry.org\/blog_tech\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1174"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}