Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

I have a data view and am trying to filter using 2 date filter web parts. I'm assigning the date filter values to parameters ($StartDateFilter and $EndDateFilter). I'm struggling with the filter data view filter condition.

I have tried the following:

<xsl:variable name="ConvertedStartDateFilter" select="number(ddwrt:FormatDateTime(string($StartDateFilter), 2057, 'yyyyMMdd'))" />
<xsl:variable name="ConvertedEndDateFilter" select="number(ddwrt:FormatDateTime(string($EndDateFilter), 2057, 'yyyyMMdd'))" />      
<!-- Filter using @StartDate 'translate' -->
<xsl:variable name="Rows" select="/dsQueryResponse/Work/Rows/Row[number(translate(@StartDate,'/','')) &gt;= $ConvertedStartDateFilter and number(translate(@StartDate,'/','')) &lt;= $ConvertedEndDateFilter]"/>        

The problem is that @StartDate is translated into yyyyddMM which obviosly gives the wrong results. I need it to be in yyyyMMdd.

So I have tried replacing the last line above with:

<!-- Filter using 'FormatDateTime' -->
<xsl:variable name="Rows" select="/dsQueryResponse/Work/Rows/Row[number(ddwrt:FormatDateTime(string(@StartDate), 2057, 'yyyyMMdd')) &gt;= $ConvertedStartDateFilter and number(ddwrt:FormatDateTime(string(@StartDate), 2057, 'yyyyMMdd')) &lt;= $ConvertedEndDateFilter]"/>

but this causes the page to throw the generic 'Unable to display this Web Part' error.

I know that the statement number(ddwrt:FormatDateTime(string(@StartDate), 2057, 'yyyyMMdd')) works because I have pasted this into one of the columns of my data view and it outputs the date in the correct format (yyyyMMdd) with no page error.

So it seems that this statement just doesn't work in the filter.

Can anyone advise what I'm doing wrong / how I can do this.

Thanks in advance

TAO

share|improve this question
add comment

1 Answer 1

up vote 1 down vote accepted

So it seems there's an issue converting European format dates. I implemented the filter by breaking up the date parts and concatenating to yyyyMMdd:

<!-- Filter using concat and substring -->
<xsl:variable name="Rows" select="/dsQueryResponse/Work/Rows/Row[number(concat(substring(string(@StartDate),7,4),substring(string(@StartDate),4,2),substring-before(string(@StartDate),'/'))) &gt;= $ConvertedStartDateFilter and number(concat(substring(string(@StartDate),7,4),substring(string(@StartDate),4,2),substring-before(string(@StartDate),'/'))) &lt;= $ConvertedEndDateFilter]"/>        

Thanks go to Andrej Dobrovoljc for this post.

share|improve this answer
    
So accept your answer... –  banana Oct 6 '13 at 8:23
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.