One more note, if I use current date instead of trying to build a date, everything works fine:

<xsl:variable name="startDateShow">
<xsl:value-of select="umbraco.library:FormatDateTime(umbraco.library:CurrentDate(), 'MM/1/yyyy')"/>
</xsl:variable>

Hi karen,

try this:

<xsl:variable name="defaultStartMonth" select="9"/>
  
  <xsl:variable name="startDateShow" select="concat($defaultStartMonth,'/',umbraco.library:FormatDateTime(umbraco.library:CurrentDate(), '1/yyyy'))"/>
  <xsl:variable name="endtDateShow" select="concat($defaultStartMonth,'/',umbraco.library:FormatDateTime(umbraco.library:DateAdd(umbraco.library:CurrentDate(),
 'y', 1), '1/yyyy'))"/>
  
  <xsl:value-of select="$startDateShow"/><br />
  <xsl:value-of select="$endtDateShow"/>

Greetings Dirk

Hi,

Thanks Dirk.

It is more complicated then that though, I can't base endDateShow off the defaultStartMonth because that is only default if nothing is passed in on the query string.  Also, startDateShow is based on that also. I only included a simple version of the code.  But basically startDateShow is figured out, and then endDateShow is calculated from that.  Here is the full code for figuring startDateShow, changed to use your suggestion above.

<xsl:variable name="startDateShow">
<xsl:choose>
<xsl:when test="umbraco.library:RequestQueryString('startDate') = ''">
    <xsl:value-of select="concat($defaultStartMonth,'/',umbraco.library:FormatDateTime(umbraco.library:CurrentDate(), '1/yyyy'))"/>
"/>
</xsl:when>
<xsl:otherwise>
  <xsl:value-of select="umbraco.library:FormatDateTime(umbraco.library:RequestQueryString('startDate'), 'MM/dd/yyyy')"/>
</xsl:otherwise>
</xsl:choose>
</xsl:variable>

but this stll gives me the same error when trying to do endDateShow.

It seems that doing the DateAdd on a constructed date string is not working.

Actually, doing any Date function (like DateGreaterThanOrEqual) on a 'built' string is not working.

I am not sure how to convert the built date string into something those functions like.

Doing

<xsl:variable name="startDateShow">
9/1/2011
</xsl:variable>

but using any variables or parameters does not:  (actually just noticed a glaring error in my original post - the xslt should actually be the following to output defaultStartMonth, forgot the value-of in the original!)

<xsl:variable name="startDateShow">
<xsl:value-of select="$defaultStartMonth"/>/1/<xsl:value-of select="umbraco.library:FormatDateTime(umbraco.library:CurrentDate(),'yyyy')"/>
</xsl:variable>

using the first value (hard coded 9/2/2011) I can do DateAdd or DateGreaterThanOrEqual or whatever.  But using the second 'calculated' date will not let me save the xslt and gives an xslt error if you try to run it.

You should pass XSLT dates around as yyyy-mm-dd, for starters. The .NET functions will always correctly parse that too.

Dirk: When you set $startDate, you are missing a $ on currentYear

P.S. Fairly you will need the zero padding on that format, which you can get with:

<xsl:variable name="fullDate">
<xsl:value-of select="$y"/>
<xsl:text>-</xsl:text>
<xsl:number format="01" select="$m"/>
<xsl:text>-</xsl:text>
<xsl:number format="01" select="$d"/>
</xsl:variable>

Or to be slightly less verbose:

<xsl:variable name="fullDate">
<xsl:value-of select="$y"/>-<xsl:number format="01" select="$m"/>-<xsl:number format="01" select="$d"/>
</xsl:variable>

Hi Rob,

as far as I can see a request like ... /date.aspx?startDate=2011-1-31&endDate=2011-2-3 works fine without - even leading 0 or anthing else you are mentioning;-)

Yours Dirk

PS: date.aspx is just a template with the corresponding macro included.

ok I think the keys to getting this to work is to make sure to add to the test test="$startDateShow and $endDateShow" everytime you want to do any of the date functions on one of those as well as using the ShortDate functions

Thanks a lot!

Hi Dirk, fair enough! I did have problems with padding recently but I can't remember at all where so it was just a vague possibility :o)

is working on a reply...