Problem in query result

See more:

SQL

database

SELECT     FileNo, ReqControlNo, Requester, ReqDate, IssueDate, DueDate, RequesterDeptt, Remarks, HandOverTo, RecordType, ReceivedDate, ProjectName,
                      ReceivedRemarks, IssueTime, ReceiveTime
FROM         Issue
WHERE     (format(IssueDate, 'dd-mm-yyyy') BETWEEN format(?, 'dd-mm-yyyy') AND format(?, 'dd-mm-yyyy')) OR
                      (format(ReceivedDate, 'dd-mm-yyyy') BETWEEN format(?, 'dd-mm-yyyy') AND format(?, 'dd-mm-yyyy'))
ORDER BY ReceivedDate

It returns 677 results.

SELECT     FileNo, ReqControlNo, Requester, ReqDate, IssueDate, DueDate, RequesterDeptt, Remarks, HandOverTo, RecordType, ProjectName,
                     IssueTime From         Issue
WHERE     (format(IssueDate, 'dd-mm-yyyy') BETWEEN format(?, 'dd-mm-yyyy')

it returns 362 results.

SELECT     FileNo, ReqControlNo, Requester, ReqDate, IssueDate, DueDate, RequesterDeptt, Remarks, HandOverTo, RecordType, ReceivedDate, ProjectName,
                      ReceivedRemarks, IssueTime, ReceiveTime
FROM         Issue
WHERE     ( (format(ReceivedDate, 'dd-mm-yyyy') BETWEEN format(?, 'dd-mm-yyyy') AND format(?, 'dd-mm-yyyy'))

it returns 338 results.
why Query1 result !=Query2+query3 results.
it's very urgent.
help me!
Problem is that the first query is not include those files that are issued and received same day.


Update from OP: I got the solution.It's my conceptual mistake.