SharePoint DataView Show Items from last week -
I have SharePoint DataView WebPart which is set to combine data with some different lists. I want to filter to show data I'm able to filter it to show data from this week, but I failed to show last week's data.
I have set up a Web Part filter set below:
It translates the following XSL:
& lt; Xsl: variable name = "rows" = "/ dsQueryResponse / rows / row [number (translate (sub-base (@ wik_x0020_starting, 't'), '-', '') & amp; lt; = number (Translate (first $ $, today, 't'), '-', '') and number (translate (before sub-letter (@ weeks_x0020_ ending, 't'), '-' '')) & Amp; gt; = number (translate (first letter $ $, 't'), '-', '')] / />
I guess I understand this Need [current date] - 7, however, I did not understand how to subtraction Is there anyone facing such a situation? Am I going to go about this right? / P>
I managed to hack something which I want to:
I have created a calculation column on that list that shows the beginning of the week + 7 days, And used it to compare with the current date.
Comments
Post a Comment