You shouldn't need the
... is not null
bit because null is not greater than any date.
The error is because the date is not quoted, so it is comparing the date in the column with the number 2007 (2009 - 1 - 1).
Try this instead:
select count(*) from passengermaster where ticket_issue_date > '2009-01-01';