ColumnFilter / Date Format issue

0
0

HI all,

we have a column filter added to DataGridView, column that would need to be filtered is BirthDate, we are using HR-hr regional settings.

When entering the filter criteria in colWhere we are experiencing “Object cannot be cast from DBNull to other types”

This is probably issue of converting date string to date datatype.

Can you please take look into the issue.

Regards,

D

  • You must to post comments
0
0

Hi Dino,

thanks for providing further information and a test case.

I have enhanced the column filter to handle null DateTime values.

Please update from https://github.com/iceteagroup/wisej-extensions

It will also be included in the next Wisej release.

Best regards
Frank

  • Levie (ITG)
    Hi Dino, does this solve your issue? Let me know! Best, Levie
  • You must to post comments
0
0

Hi Frank,

please find attached sample.

Please note that this error is raised when there is NULL value in the column that you are trying to filter, I was expecting that his rows will be ignored / filtered by default.

Regards,

Dino

  • You must to post comments
0
0

Hi Dino,

can you please wrap up a small test case ?
You can either post it here or send it to frankATiceteagroup.com

Thanks in advance.

Best regards
Frank

  • You must to post comments
Showing 3 results
Your Answer

Please first to submit.