SELECT FileNo, ReqControlNo, Requester, ReqDate, ReqTime, IssueDate, IssueTime, DueDate, RequesterDeptt, HandOverTo, ReceivedDate,
ProjectName
FROM Issue
WHERE (format(IssueDate, 'dd-mm-yyyy') BETWEEN format(?, 'dd-mm-yyyy') AND format(?, 'dd-mm-yyyy'))
I have taken IssueDate as text In Table.
When I find data between same date it retrieves right results.
But when I find data between different date It retrieves Wrong results.
For Example:
From 25-07-2011 to 25-07-2011 returns Right results.
From 23-07-2011 to 25-07-2011 returns wrong results, It picks result of between 23 to 25.It does not check Months.
Please Help me.