I have a database table which has 2 fields orderDate and orderAmount. Now I need to create date range as from-order-date and to-order-date in 2 separate list box by using orderDate field. And also need sum(orderAmount) when customer select from-order-date and to-order-date from those list boxes.
orderDate
orderAmount
1/1/2015
1000
14/2/2015
4500
31/3/2015
200
30/4/2015
800
14/6/2015
3500
Anyone please provide video or process step by step.