Date time range search(list column search) is not proper due to timezone conversion (such as search in created time and modified time)
Scenario:
Suppose we need to search for all contact that were created between 1 June 2016 and 7 June 2016, from the created time column, date range which should be selected is 1-06-2016,7-06-2016.
But if the user's timezone is other than UTC, then results would include records with created datetime either 1 day earlier or after (depending on timezone offset from UTC).
Reason: This happens because in the date range selection there is no time component. As such the user input date is taken as it is and appends 00:00:00.
Solution: introduce time selection as well so that before query, users input could be transformed to proper time zone.