Hello,
I am working on a project that currently contains a RadGrid and RadFilter control for the grid. It has been very helpful in getting the filtering that I need done!
However, in my grid, I have a DateTime column that has date and time in seconds. The way the data in my database is set up, there are entries that only differ by seconds, so I want to be able to filter down to the "second" level. When I use the RadFilter to filter on this column, it lets me type in the exact date and time (with seconds) I need and works as expected. But when I apply the filter, if I had written the time in seconds, it automatically changes the look of the query to hh:mm tt. Even though the query takes into account the seconds I entered, they are no longer displayed in my current filter.
Is there currently any way to edit how date and time are displayed in RadFilter, or can I only get it shown as "mm/dd/yyyy hh:mm tt"?
Thanks!
EDIT: Sorry for the double post! I got a server error the first try, but apparently it still went through.
I am working on a project that currently contains a RadGrid and RadFilter control for the grid. It has been very helpful in getting the filtering that I need done!
However, in my grid, I have a DateTime column that has date and time in seconds. The way the data in my database is set up, there are entries that only differ by seconds, so I want to be able to filter down to the "second" level. When I use the RadFilter to filter on this column, it lets me type in the exact date and time (with seconds) I need and works as expected. But when I apply the filter, if I had written the time in seconds, it automatically changes the look of the query to hh:mm tt. Even though the query takes into account the seconds I entered, they are no longer displayed in my current filter.
Is there currently any way to edit how date and time are displayed in RadFilter, or can I only get it shown as "mm/dd/yyyy hh:mm tt"?
Thanks!
EDIT: Sorry for the double post! I got a server error the first try, but apparently it still went through.