Hi Aswini,

I tried to replicate your issue in our local end using WebGrid with DateTime data inside it. However, when I filter the data using Date only, it only shows the data which have the same date (I don't have to put the time). I also attach my sample here. Could you please look at my sample and tell me if there's any misconfiguration in my sample. Look forward to hear any feedback from you so I can help you further.

Regards,
Bernard

hi Bernard,

i have tried but "Equals To" filter is working fine only for the date those have time part "12:00:00 Am",

 http://live.intersoftpt.com/Default.aspx?url=cs/WebGrid/AutomaticFilterSuggestion.aspx 

Go through the above link they have used the date those have time part "12:00:00 AM", so that all filter will work fine , but if we will change the time part as "01:35:24 Am" then it won't work.    

Thanks with Regards 

Aswini Maharana

Hi Aswini,

I think this problem might happen because it's default behavior from MSSQL and Access database datetime data type. Actually, our filter will put the parameter inside filter column to server side then it will re-query the data using SQL statement (in this case using "equals to"). We also found out that this matter happen in MSSQL and Access database.

I also tried to convert the data type from datetime to date when selecting. but this method won't work for filtering. Maybe if you want, I will made this as feature request so our developer team will look further for this matter and if possible they will made a workaround regarding this problematic behavior.

Look forward to hear any feedback from you so I can help you further.

Regards,
Bernard