Hi guy's...
I'm totally lost here..because don't have any idea how to make a query for grab record using BETWEEN startdate and enddate since existing record are stored using this format datetime(dd/mm/yyyy hh:mm:ss) but my supplied $startdate and my $enddate are in this format date(dd/mm/yyyy) only....hope someone will shed me some light on this...is it possible to grab those record...??
//example of my query..
$sqlquery = "SELECT * FROM sometable WHERE OFFENCE_NOTICE_STATUS = 'A' AND CREATED_DATE BETWEEN ".$start_date." AND ".$end_date;
//can't run this query because of the stored record in database are in different format datetime(dd/mm/yyyy hh:mm:ss)
//my supplied variable in date(dd/mm/yyyy) format...
Any help are appreciated TQ..
