Searching between two dates in a list.
this is not a default view in 2003.
there are links that enable and help is understanding more about it.
in simple terms. Create 2 text boxes in form
and name them start date and end date
create parameter in data view for start date and end date
create filter for start date and end date
set default value for start date as 1500-01-01
default value for end date as 3500-01-01 - this will display all items
connect the boxes and use the format as yy-mm-dd else it wont work
important references:
http://yanlinglei.blogspot.in/2010/02/filter-between-two-dates-using-dataview.html
http://yanlinglei.blogspot.in/2008/11/filter-between-two-dates-date-range.html
http://social.technet.microsoft.com/Forums/eu/sharepointadminlegacy/thread/a8cce2af-3900-4421-8fc0-91d9adc315ad
datepicker() modified as
datepicker({ dateFormat: 'yy-mm-dd'});
http://docs.jquery.com/UI/Datepicker/formatDate
http://stackoverflow.com/questions/7500058/how-to-change-date-format-mm-dd-yy-to-yyyy-mm-dd-in-date-picker
Text boxes sample - form webpart
------------------
<div onkeydown="javascript:if (event.keyCode == 13) _SFSUBMIT_">
<head>
<meta charset="utf-8" />
<link rel="stylesheet" href="jquery-ui.css" />
<script src="jquery-1.8.3.js"></script>
<script src="jquery-ui.js"></script>
<link rel="stylesheet" href="style.css" />
<script>
$(function()
{
$( "#datepicker" ).datepicker({ dateFormat: 'yy-mm-dd'});
$( "#datepicker1" ).datepicker({ dateFormat: 'yy-mm-dd'});
});
</script>
</head>
Start Date: <input type="text" name="T1" id="datepicker" />
End Date : <input type="text" name="T2" id="datepicker1" /><input type="button" value="Go" onclick="javascript:_SFSUBMIT_"/>
</div>
</html>
this is not a default view in 2003.
there are links that enable and help is understanding more about it.
in simple terms. Create 2 text boxes in form
and name them start date and end date
create parameter in data view for start date and end date
create filter for start date and end date
set default value for start date as 1500-01-01
default value for end date as 3500-01-01 - this will display all items
connect the boxes and use the format as yy-mm-dd else it wont work
important references:
http://yanlinglei.blogspot.in/2010/02/filter-between-two-dates-using-dataview.html
http://yanlinglei.blogspot.in/2008/11/filter-between-two-dates-date-range.html
http://social.technet.microsoft.com/Forums/eu/sharepointadminlegacy/thread/a8cce2af-3900-4421-8fc0-91d9adc315ad
datepicker() modified as
datepicker({ dateFormat: 'yy-mm-dd'});
http://docs.jquery.com/UI/Datepicker/formatDate
http://stackoverflow.com/questions/7500058/how-to-change-date-format-mm-dd-yy-to-yyyy-mm-dd-in-date-picker
Text boxes sample - form webpart
------------------
<div onkeydown="javascript:if (event.keyCode == 13) _SFSUBMIT_">
<head>
<meta charset="utf-8" />
<link rel="stylesheet" href="jquery-ui.css" />
<script src="jquery-1.8.3.js"></script>
<script src="jquery-ui.js"></script>
<link rel="stylesheet" href="style.css" />
<script>
$(function()
{
$( "#datepicker" ).datepicker({ dateFormat: 'yy-mm-dd'});
$( "#datepicker1" ).datepicker({ dateFormat: 'yy-mm-dd'});
});
</script>
</head>
Start Date: <input type="text" name="T1" id="datepicker" />
End Date : <input type="text" name="T2" id="datepicker1" /><input type="button" value="Go" onclick="javascript:_SFSUBMIT_"/>
</div>
</html>
No comments:
Post a Comment