I have a data view that needs to display all pages that are current and the closing date is greater than or equal to today's date.
The issue I am having is that the data view is displaying pages that are have the a future scheduled start date or the scheduled end date is past, i.e. something that has a start date of tomorrow, is displaying and a page that has an end date of yesterday
I can tried to filter the data view on the scheduled start and end dates but I can't see it in the Filter Options of the 'Common Data View Tasks'.
I have also tried adding XSLT Filtering but am unsure how to set it up. I have added the following as an XSLT filtering
[@PublishingStartDate<=$Today or string-length(@PublishingStartDate)=0]
I am wanting to check whether I have done this correctly or not. Some pages won't have a scheduled start date but all will have an end date.
Below is the code from my data view:
<WebPartPages:DataFormWebPart runat="server" ShowWithSampleData="False" AllowRemove="True" AllowHide="True" SuppressWebPartChrome="False" PartImageLarge="" ViewContentTypeId="" ExportMode="All" Dir="Default" MissingAssembly="Cannot import this Web Part." ID="g_fdf00570_38e8_4df9_8ab3_5ca3ed974c41" DataSourceID="" IsIncludedFilter=""
View Complete Post