SfDatagrid DateTime column in format DD.MM.YYYY not filtering

[Mairis Kalmikovs]

Hello!

I have Windows region settings for Latvia.

Short date format DD.MM.YYYY 

https://prnt.sc/w2j1aa

Grid loads data fine from PostgreSQL database, but when filtering it doesn't filter data. Returns 0 records.

So image before filtering: 

http://prntscr.com/w2j8a5

Result 0 records:

http://prntscr.com/w2j8qh

Setting Column FilterMode  doesn't fix this problem.

If i change to different date formats filtering works fine.

I created as minimal as possible project to reproduce this problem.

Attachment: WindowsApp1_1916086c.rar

[Mohanram Anbukkarasu]

Hi Mairis, 

Thanks for contacting Syncfusion products.  

We are able to reproduce the reported issue in our end. On analysis, we found that it occurs only when using DataTable as DataSource. We are currently validating this. We will check and update with further details on 17^th December 2020. We appreciate your patience until then.  

Regards, 

Mohanram A. 

[Mohanram Anbukkarasu]

Hi Mairis, 

Thanks for your patience.  

We have checked the reported issue and it occurs only when using DataTime.Now in DataTable. You can make use of DateTime.Today or DataTime.Now.ToShortDateString() to resolve this issue. We have modified the sample and it is available in the following link for your reference.  

Sample link : https://www.syncfusion.com/downloads/support/forum/160628/ze/WindowsApp1_Modified1915668168  

Please let us know if you have any concerns in this.  

Regards, 

Mohanram A. 

[Mairis Kalmikovs]

Hi Mohanram,

Thank you for reply.

But if i wanted to show Date and Time in same column then this is not possible?

[Mohanram Anbukkarasu]

Hi Mairis,  

Thanks for the update.   

We are able to understand the reported scenario. We are currently validating this. We will check and update with further details on December 22, 2020. We appreciate your patience until then.   

Regards,  

Mohanram A. 

[Mohanram Anbukkarasu]

Hi Mairis, 

Thanks for your patience.  

We have checked the reported scenario. This issue occurs only when using DateTime.Now with DataTable as DataSource. To apply filter for DataTable internally we have used DataView.RowFilter support. On analysis, the reported issue occurs in DataView.RowFilter when using DateTime.Now. We have raised a query regarding this in developers community.  

Query link : https://developercommunity.visualstudio.com/content/problem/1293273/dataviewrowfilter-is-not-working-for-datetimenow.html  

We will update with further details once we get any proper solution for this query.  

Regards, 

Mohanram A.