“Count number of new entries” – Forum Thread – Discuss

Count number of new entries

This is an open discussion with 1 reply, filed under XSLT.

Search

You are looking at page 1 of 1

- whgdesign
- 28 May 11, 4:55 am
- Comment #1

Hi there,

I'm trying to count the number of new added entries younger than 8 day's.

I have two sections, one with the provinces of The Netherlands (total of 12) and another with terraces. Each entry inside the terraces section has an unique ID and the location information (such as the province and place).

I already now how to count the total of the terraces inside each province.

<xsl:template match="provinces/entry">
    <xsl:variable name="province" select="province/@handle"/>
    <xsl:variable name="new" select="count(//statics-total-terraces/entry[province/item/@handle = $province])"/>
</xsl:template>

But now I have to count the terraces which date is younger than 8 day's. I don't know how to do this?

My xml for the terraces

<statics-total-terraces>
    <section id="8" handle="terrace">Terrace</section>
    <entry id="160">
        <date-added time="22:06" weekday="1">2011-05-02</date-added>
        <place handle="amsterdam">Amsterdam</place>
        <province>
            <item handle="noord-holland">Noord-Holland</item>
        </province>
        <terrace-id handle="160-the-cafe">160-the-cafe</terrace-id>
    </entry>
</statics-total-terraces>

My xml for the provinces

<provinces>
    <section id="14" handle="provinces">Provinces</section>
    <entry id="221">
        <province handle="drenthe">Drenthe</province>
    </entry>
    <entry id="221">
        <province handle="brabant">Brabant</province>
    </entry>
    <entry id="221">
        <province handle="noord-holland">Noord-Holland</province>
    </entry>
</provinces>

- czheng
- 29 May 11, 11:00 am
- Comment #2

Here's a hint. You can use EXSLT's date-difference.

Create an account or sign in to comment.

Symphony.