Hi Wilson

I've deleted the other post for you and I've removed the "(previous...)" part of the title for this one.

Must admit that I have not looked very deeply on the above code - but one thing that springs to my eye is that you're trying to manipulate text strings and not numbers. If you make a <xsl:value-of select="$todaysDate" /> it will return a value like this 2011-11-23T19:56:27 and so does @createDate.

So in order to be able to substract the two dates you need to do the following

1) Get rid of the time information

2) Get rid of "-" so you have a number like 20111123

This can be done by using substring-before() and translate(), which are native XSLT functions. The way we're using the Translate() function is also referred to as a "poor man's replace" (Thank's to Chriztian Steinmeier for teaching that waaay back).

So in your last template I would make two variables, one called now and one called createDate like shown below.

<xsl:variable name="now" select="translate(substring-before($todaysDate,'T'),'-','')">
<xsl:variable name="createDate" select="translate(substring-before(@createDate,'T'),'-','')">

The substring-before() makes sure you only get the date without the time and the translate removes the "-".

Now you can make a substraction by doing this number($now)-number($createDate) &gt; number(30).

You could also make specify that the content of the variable should be a number by adding it like this
<xsl:variable name="now" select="number(translate(substring-before($todaysDate,'T')),'-','')" />.

I hope the above makes sense and helps :)

/Jan

Oops! Note to self, don't edit the title of posts...apparently it messes up the content of it...#h5is...

If the above post does not solve your issue, please post the code in the reply once again. Our has some bugs that means it's not currently possible for you to edit posts yourself.

/Jan

Hi Jan,

Thank you for your response and your time I am working on this at the moment and will post a reponse as soon as I get this this working.

Hi Jan,

I was finally able to get it working using the following extension method.

As date calculations turned out to be more complicated than just date1 - date 2 (yeah i know :P)

Pasting the code below for extension method and how i used it in apply templates for any one who has questions post here and I would be happy to help.

xmlns:wilson="http://wilson.co.uk/"

<xsl:apply-templates select="$currentPage/ancestor-or-self::*[@level=1]//* [@isDoc and string(umbracoNaviHide) != '1' and wilson:isOnlyAMonthOld(@createDate)]">
          <xsl:sort select="@createDate" order="descending" />
</xsl:apply-templates>

<msxsl:script implements-prefix="wilson"  language="C#">
    <![CDATA[
       
        public bool isOnlyAMonthOld(string dateString)
        {   
            DateTime updateDate;
            const string format = "s";

            DateTime now = DateTime.Now;
            DateTime aMonthAgoDate = now.AddMonths(-2);
            updateDate = DateTime.ParseExact(dateString, format, null);

            if (updateDate >= aMonthAgoDate)
            {
                return true;
            }
            else
            {
                return false;
            }
        }
           
        ]]>
  </msxsl:script>

           
        public bool isOnlyAMonthOld(string dateString)
        {   
            DateTime updateDate;
            const string format = "s";

            DateTime now = DateTime.Now;
            DateTime aMonthAgoDate = now.AddMonths(-2);
            updateDate = DateTime.ParseExact(dateString, format, null);

            if (updateDate >= aMonthAgoDate)
            {
                return true;
            }
            else
            {
                return false;
            }
        }
           
        ]]>
 

           
        public bool isOnlyAMonthOld(string dateString)
        {   
            DateTime updateDate;
            const string format = "s";

            DateTime now = DateTime.Now;
            DateTime aMonthAgoDate = now.AddMonths(-2);
            updateDate = DateTime.ParseExact(dateString, format, null);

            if (updateDate >= aMonthAgoDate)
            {
                return true;
            }
            else
            {
                return false;
            }
        }
           
        ]]>
 

Just a note:  the method "isOnlyAMonthOld" pasted twice is just becuase i tried to edit my own.

@Jan another bug mate :-(

is working on a reply...