none
Filter a data view web part using date and time RRS feed

  • Question

  • I am trying to display data form sharepoint 2007 list using data view web part.  The data view should only display data the is created between a date/time range.

    

    The Start date value consists of a date from date filter web part and Start Time value consists of value form text filter web part.Same is done for End Date and End Time.

    The selectcommand of the data view that i changed is  

    <View><Query><Where><And><Geq><FieldRef Name="Created"/><Value Type="DateTime" IncludeTimeValue="TRUE" >{SD1}T{ST1}Z</Value></Geq><Leq><FieldRef Name="Created"/><Value Type="DateTime" IncludeTimeValue="TRUE" >{ED1}T{ET1}Z</Value></Leq></And></Where></Query></View>

    where SD1= Start Date Filter value, ST1=Start Time TextFilter Value

    ED1= End Date Filter value , ET1=End Time TextFilter Value 

    I have also created the web part connections, but it is not displaying any results. Can anyone please help me how to do that.



    • Edited by NKJ_90 Tuesday, June 11, 2013 4:07 PM
    Tuesday, June 11, 2013 3:39 PM

All replies