Hi Pranav,
I think it could help if you provide a screenshot of the data in the grid and the criteria entered in the search.
You should include the Time in your search box if you select like that.
Or if you use date only without time you should say :
datetimefromdatabase >= day(X) and datetimefromdatabase <= day(X+1)
I am a bit confused about your time-criteria.
If I would filter I would filter like this: [fromdatetime <= datetimefromdatabase <= todatetime]
Have a try or add some screen shots..
Goodluck
Screenshot for From date time dropdown –
Screenshot for to datetime dropdown –
Screenshot of data grid –
Screenshot of data in data grid –
As you can see here, from date and to date are both 4th dec, but data for 5th dec upto 7 pm is also showing up