<pre lang="xml">This is sample data table. PURC_ID---------PRICE---------UNIT------------------QTY--------Date_Purchased IP-16701--------233981--------Samsung Gal S--------1--------7/1/2014 10:03:59 PM IP-16701--------233981--------Samsung Gal S--------1--------7/5/2014 10:03:59 PM IP-16701--------233981--------Samsung Gal S--------1--------7/22/2014 7:03:59 PM IP-16701--------233981--------Samsung Gal S--------1--------8/3/2014 10:03:59 PM IP-16701--------233981--------Samsung Gal S--------1--------8/10/2014 8:03:59 PM IP-16701--------233981--------Samsung Gal S--------1--------8/15/2014 9:03:59 PM IP-95975--------180866--------Sony Xperia Z--------1--------8/25/2014 1:31:53 PM IP-95975--------180866--------Sony Xperia Z--------1--------8/26/2014 1:31:53 PM This is what I want to do. If I choose weekly it will get all the data from the current date until the starting date which is Monday. The format will be Monday - Sunday for weekly. IP-95975--------180866--------Sony Xperia Z--------1--------8/25/2014 1:31:53 PM IP-95975--------180866--------Sony Xperia Z--------1--------8/26/2014 1:31:53 PM and If I choose monthly it will display all the data from Day 1 - 31. IP-16701--------233981--------Samsung Gal S--------1--------8/3/2014 10:03:59 PM IP-16701--------233981--------Samsung Gal S--------1--------8/10/2014 8:03:59 PM IP-16701--------233981--------Samsung Gal S--------1--------8/15/2014 9:03:59 PM IP-95975--------180866--------Sony Xperia Z--------1--------8/25/2014 1:31:53 PM IP-95975--------180866--------Sony Xperia Z--------1--------8/26/2014 1:31:53 PM
"SELECT ProductID,Price,ProductName,Qty FROM Transaction Where Date_Purchased between '" + ddldatestart + "' AND '" + ddldateend + "'";
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)