this is my date picker in html its execute perfect in preview pattern .........
now my question is how to pass parameter by script to get value for date record
my dateset is
SELECT O_OUTLET_NAME as 'NAME',OIF_ITEM_CODE as 'code',IM_ITEM_NAME as 'ITEM NAME',OIF_RATE as 'RATE',OIF_QTY*OIF_RATE as 'AMOUNT',OIF_DISCOUNT as 'DISCOUNT',OIF_TAX as 'TAX',OIF_AMOUNT as 'NETAMOUNT'
FROM SS_OUTLET_ITEMWISE_FACT,SS_ITEM_MASTER,SS_OUTLET
WHERE OIF_ITEM_CODE=IM_ITEM_CODE AND
IM_BRAND_ID=1 AND
OIF_OUTLET_ID=O_NEW_OUTLET_ID and
OIF_tRAN_dATE='2012-12-01'
ORDER BY OIF_AMOUNT DESC
LIMIT 10;
my date picker in html:
<!doctype html>
<html lang="en">
<head>
<meta charset="utf-8" />
<title>jQuery UI Datepicker - Default functionality</title>
<link rel="stylesheet" href="
http://code.jquery.com/ui/1.10.1/themes/base/jquery-ui.css" />
<script src="
http://code.jquery.com/jquery-1.9.1.js"></script>
<script src="
http://code.jquery.com/ui/1.10.1/jquery-ui.js"></script>
<link rel="stylesheet" href="/resources/demos/style.css" />
<script>
$(function() {
$( "#datepicker" ).datepicker();
});
$(function() {
$( "#datepicker1" ).datepicker();
});
</script>
</head>
<body>
<p>from: <input type="text" id="datepicker" /> to: <input type="text" id="datepicker1" /></p>
</body>
</html>
so give script according to my dataset ...am strugling ......give script to execute in webviewer
