Date in varchar format not working with query with date

  mysql, php

I have a field name ‘orderdate’ (type Date format yyyy-mm-dd).when i am executing the following query it doesnot show any result.What may be the problem, is the date format used in my query creating problem.plz soggest any solution .I can not change the format of orderdate in table. my query is

 SELECT  stationerytype,
txntype,
stationeryqtyrecd,
stationeryqtyissued,
stationeryissueddate,
orderdate,SUM(stationeryqtyrecd) as ttlreceived  
FROM tblstationerystock 
WHERE (stationerytype ='A4 White Ream' AND  txntype ='received') AND orderdate<07/09/21

Source: Ask PHP

LEAVE A COMMENT