fljkclfikjk
New Member
I am facing issue with following query in fetching records between two dates in \[code\]DD/MM/YYY\[/code\] format from MS Access. I am getting records of all months till March. Please help me.Let me know if full code is required to analyse completely.\[code\]SELECT * FROM CodeReviewTable WHERE (Format((CodeReviewTable.DevDate),'DD/MM/yyyy') >= '04/02/2013') and (Format((CodeReviewTable.DevDate),'DD/MM/yyyy') <= '18/03/2013'); \[/code\]I have checked the format of date like below. It is showing in \[code\]dd/mm/yyyy\[/code\] format only.\[code\]DateTime startdate = new DateTime();DateTime enddate = new DateTime();bool isstartdate = DateTime.TryParse(txtStartDAte.Text,null, System.Globalization.DateTimeStyles.None, out startdate);bool isenddate = DateTime.TryParse(txtEndDate.Text,null, System.Globalization.DateTimeStyles.None, out enddate);\[/code\]