Hi,
How does XSLT calculate the number of days between these two dates?

my first date date1 and second date date2

data1: <xsl:value-of select="//n1:Invoice/cac:PaymentMeans/cbc:PaymentDueDate" disable-output-escaping="yes" />

date2: <xsl:value-of select="//n1:Invoice/cbc:IssueDate" disable-output-escaping="yes" />

i want date2-date1= ... day

How will this be spelled? Thank you..

Not sure why you are disabling output escaping for a date? Surely a date will never contain any characters that need to be escaped anyway. (Some people use disable-output-escaping as magic fairy dust without understanding what it does. Don't do that - it's dangerous!)

XSLT 2 can subtract two dates if they are in ISO format simply as

xs:date(d1) - xs:date(d2)

The result is an xs:duration which can be converted to number of days by doing

(xs:date(d1) - xs:date(d2)) div xs:duration('PT1D')

XSLT 1 doesn't have any facilities for date arithmetic, you need an extension library such as the EXSLT date library if available for your chosen processor.

__________________
Michael Kay
http://www.saxonica.com/
Author, XSLT 2.0 and XPath 2.0 Programmer\'s Reference

Unfortunately I could not. I do not have much information. Could you make an example from the codes I sent? Thank you..

Hello I wrote it like below but it gives an error. Is this a correct spelling?


<xsl:value-of select="(xs:date('2012-12-20')-xs:date('2012-12-10')) div xs:duration('PT1D')"/>

<xsl:value-of select="(xs:date('2012-12-20')-xs:date('2012-12-10')) div xs:dayTimeDuration(P18D)"/>

This is the mistake he gives in all ..

"XalanXPathException: The function number 'http://www.w3.org/2001/XMLSchema:date' is not available...."

Hello I wrote it like below but it gives an error. Is this a correct spelling?


<xsl:value-of select="(xs:date('2012-12-20')-xs:date('2012-12-10')) div xs:duration('PT1D')"/>

<xsl:value-of select="(xs:date('2012-12-20')-xs:date('2012-12-10')) div xs:dayTimeDuration(P18D)"/>

This is the mistake he gives in all ..

"XalanXPathException: The function number 'http://www.w3.org/2001/XMLSchema:date' is not available...."

Xalan only supports XSLT and XPath 1.0 so you need to use Saxon 9 or another XSLT 2.0 processor to use the suggestions made so far.

__________________
Martin Honnen
Microsoft MVP (XML, Data Platform Development) 2005/04 - 2013/03
My blog

My xml version="1.0" and ubl 2.1

I made it pretty clear in my answer that you need XSLT 2.0 for this.

XSLT 2.0 means version 2.0 of XSLT. It's nothing to do with the version of XML or the version of UBL.

__________________
Michael Kay
http://www.saxonica.com/
Author, XSLT 2.0 and XPath 2.0 Programmer\'s Reference

My XSLT version 2.0


<xsl:stylesheet version="2.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform"


Why is still the same error

Labelling your stylesheet as version 2.0 doesn't suddenly make Xalan into an XSLT 2.0 processor. You need an XSLT processor that understands XSLT 2.0, such as Saxon.

__________________
Michael Kay
http://www.saxonica.com/
Author, XSLT 2.0 and XPath 2.0 Programmer\'s Reference