My data is in foll format ID| UID | Branch_Code | Transaction_Date | Description | Amount_Final | As_Of_Date || 1| zaere | 0 | 20-08-2004 | Description1 | 39232 | 31-01-2014 || 2| zaere | 0 | 23-03-2011 | Description2 | 80 | 31-01-2014 || 3| zaere | 0 | 20-08-2004 | Description1 | 39232 | 28-02-2014 || 4| zaere | 0 | 23-03-2011 | Description2 | 80 | 28-02-2014 || 5| zaere | 0 | 23-03-2011 | Description2 | 80 | 28-02-2014 || 6| abc | 0 | 24-03-2011 | Descri |100 | 28-02-2014 || 7| pqr | 0 | 11-03-2011 | Des | 2000 | 31-01-2014 ||
SELECT <FieldList> FROM <TableName> WHERE As_of_Date BETWEEN '01-01-2014' AND '28-02-2014'
SELECT * FROM MyTable WHERE As_Of_Date = '2014-02-28' OR As_Of_Date = '2014-01-31'
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)