I adds a DATE column (created date of the record) into KendoUI grid, but the database format of column is DATETIME, because, I need to know also time. Problem is, when Im using filtering functionality, because when I would like to filter this column to date = for example 2018-08-08 and Im sure, that some records was created on this day, datagrid do not fond nothing. Its because, the datagrid is searching for 2018-08-08 00:00:00 and no record exists with a zero time.
Is there any way to solve this problem in datagrid or, there is needed to create two columns in the database, one as a DATETIME and second as a DATE. I have problem also with the WEEK number (I opened another discussion thread). If I need to add also the week number, I need to have 3 columns in the database for one information: DATETIME, DATE, WEEK. I think, its poor solution. Do you have any other ideas?
Thanks for help.