Dates between day

yozsubasi · March 18th, 2017, 05:15 AM

Hi,

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

Date1: 02-01-2017
Date2: 20-01-2017

Thank you.

Martin Honnen · March 18th, 2017, 05:34 AM

Assuming XSLT 2 or 3 you can construct two xs: date instances and substract them to get a duration, note however that the format to construct and xs: date is YYYY-MM-DD so you need to extract the components from your format first.

Code:

xs:date('2017-01-20') - xs:date('2017-01-02')

gives a xs:dayTimeDuration P18D

yozsubasi · March 20th, 2017, 02:11 AM

Hi, 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..

Quote:

Originally Posted by Martin Honnen

Assuming XSLT 2 or 3 you can construct two xs: date instances and substract them to get a duration, note however that the format to construct and xs: date is YYYY-MM-DD so you need to extract the components from your format first.

Code:

xs:date('2017-01-20') - xs:date('2017-01-02')

gives a xs:dayTimeDuration P18D