dear forum/phprunner programmers,
in the advanced search i am searching for records between dates. the date picker does not have hours to choose from, just the date.
when the new graph is populated the result is wrong as one record is missing. if i perform an advanced search from the record view i see all the result.
i can only assume the query created for the dates is wrong, or it does not include the entire day (i.e. problem with the hours, which i cannot input).
where can i modify the query to run correctly?
TECH DATA:
- the search is done from *_ranking_chart_search.php
- new graph result is *_ranking_chart_chart.php
- the search is for BETWEEN two dates, no choice to input hours (should default to just the days, right?)
- between sept 30th and oct 1st i had inputed 3 records to the database at the following exact date:
sept 30: 12:30:00 pm
sept 30: 1:45:00 pm
oct 1: 1:35:00 pm
if i choose sept 30th -> oct 2nd i get all 3 results.
i only get two results for sept 30th -> oct 1st
if u need more data or screenshots please let me know.
thank you for your help.