Hello,
I have a date column in my grid which shows dates in the "d" format, dd/MM/yyyy. However, the underlying data sometimes (actually most of the time) contains dates that have a non-12 AM time component, such as 12/10/1998 8:30 am. The user does not see the 8:30 am part, and when they try to use the column filter for date EdualTo 12/10/1998, they do not get a match, since the time component is not the perfect 12:00:00 am. Is there any trick to get around this issue?
I have a date column in my grid which shows dates in the "d" format, dd/MM/yyyy. However, the underlying data sometimes (actually most of the time) contains dates that have a non-12 AM time component, such as 12/10/1998 8:30 am. The user does not see the 8:30 am part, and when they try to use the column filter for date EdualTo 12/10/1998, they do not get a match, since the time component is not the perfect 12:00:00 am. Is there any trick to get around this issue?