For values of the kind of the date in the filter exist the auto-completion that operate in invisible mode to the final user and applies following rules:
- if the user insert only the year, all the time in the year specified is kept in consideration:
from 1/1/year 00:00:00 to 31/12/year 23:59:59 extrems included
- for a value that include month and year, in the form month/year worth the interval:
from 1/month/year 00:00:00 to days_in_the_month/month/year 23:59:59 extrems included
- for day, month and year (day/month/year):
from day/month/year 00:00:00 to day/month/year 23:59:59 extrems included
- for day, month, year and hour (day/month/year hour):
from day/month/year hour:00:00 to day/month/year hour:59:59 extrems included
- for day, month, year, hour and minute (day/month/year hour:minute):
from day/month/year hour:minute:00 to day/month/year hour:minute:59 extrems included
Note: Considerations indicate in the upon list worth for the "equal to" criterion; for others criterions rules change but the principle is the same and the auto-completion mode works in the following mode: making the only year specified and "bigger than" criterion example, considered interval is:
from 31/12/year 23:59:59 excluded to follow
and so on for all the other possible cases.