Posting as solution as OP has confirmed it worked.
Use an unambiguous date format so that SQL does not try to convert the string. i.e.
WHERE TransDate = '22-NOV-2015'
In response to the further comments, you can get the details for all of the dates thus:
SELECT CardType, TransDate, Sum(Amount) AS Total
FROM POSTRANS_Cards
GROUP BY CardType, TransDate
ORDER BY TransDate
Or if you want to run the report for a single date have a look at Lesson 1 on the following tutorial
Adding parameters to reports[
^]