I have what I think should be an easy question.
I have a database field which stored the timestamp. (date and time).
I want to display the timestamp as 2 columns, upload date and upload time. (please see below)
To do this I simply bind my timestamp db field (AddedDate) to both GridView columns and then apply a date format to the first one and a time format to the second one.
The problem is that when I click on the filter for the "upload date", I get the same value in the filter multiple times. It looks like this is due to the fact that the filter is applied to the underlying field value which has a time component.
In other words, based on the data:
My gridview correctly displays the previous data in 2 gridview columns. (Upload Date, Upload Time)
However, when I click on the filter for the Upload Date, I get the following:
I do not want this. I only want 5/1/2011 displayed a single time.
Is there a way to have the Telerik Gridview filter on the displayed value and not the underlying "raw" value?
Or is there another way to handle this?