If we set the “from” date as one day before the “to” date it generates a report for two days…..
And so on….
But i am unable to generate report for current date, less then equal to not working it treated as less then only.
my query is following.
Expand|Select|Wrap|Line Numbers
- SELECT `date_time` FROM `mydatatable` where `date_time` >= '$fromdate' AND `date_time` <= '$todate';