RadGrid Filter not working for GridDateTimeColumn for Equal to options

[Manishkumar]

Hi
We are using Telerik RadGrid in that we are using "GridDateTimeColumn" for Datetime Columns.If we use Filter options  as equal to for any options it is showing no datafound. We have tried various methods In the previous post from the following links
http://demos.telerik.com/aspnet-ajax/grid/examples/generalfeatures/filtering/defaultcs.aspx
http://www.telerik.com/community/forums/aspnet-ajax/grid/filter-problem-on-a-griddatetimecolumn.aspx
http://www.telerik.com/community/forums/aspnet-ajax/grid/griddatetimecolumn-filter-date-format.aspx
http://www.telerik.com/community/forums/aspnet-ajax/grid/griddatetimecolumn-filter.aspx .
Also some of the sample project downloaded from post we have tried but that too seems not to be working .

The Sample Code snippet in the aspx page we have used

 

 

 

<telerik:GridDateTimeColumn DataField="LAST_LOGON_DATE" HeaderText="Last Accessed"

 

 

 

 

 

 

 

 

DataType="System.DateTime" SortExpression="LAST_LOGON_DATE" UniqueName="LASTLOGONDATE"

 

 

 

 

 

 

 

 

PickerType="DatePicker" ItemStyle-HorizontalAlign="Left" DataFormatString="{0:dd/MM/yyyy,HH:mm}"

 

 

 

 

 

 

 

 

ItemStyle-Font-Size="8pt" HeaderStyle-Width="160px" ItemStyle-Width="160px" meta:resourcekey="LASTLOGONDATE">

 

 

 

 

 

 

 

 

</telerik:GridDateTimeColumn>

For Picker We have also tried in the ItemCreated method

 

 

 

protected void radgridAdminListUser_ItemCreated(object sender, GridItemEventArgs e)

 

{

 

 

try

 

 

 

 

 

{

 

 

if (e.Item is GridFilteringItem)

 

{

 

 

RadDatePicker picker = ((GridFilteringItem)e.Item)["LASTLOGONDATE"].Controls[0] as RadDatePicker;

 

 

 

if (picker != null)

 

{

picker.DateInput.DateFormat =

 

"dd-MM-yyyy HH:mm tt";

 

 

}

}

}

}
}
but that is also not working.
for more info please find the ScreenCapture in the attachment

[Shinu]

Hello Manish,

I have found the following forum which discussed the similar scenario.
GridDateTimeColumn "Equal To" filter problem.

Thanks,
Shinu.

[Manishkumar]

Hi Shinu;
I have tried all the things mention in this link but nothing was seems to be working
http://www.telerik.com/community/forums/aspnet-ajax/filter/griddatetimecolumn-quot-equal-to-quot-filter-problem.aspx
Can you please suggest some otherway around that how can I achive this functionality

[Manishkumar]

Hi;
Can We have Any Resolution for above issue.We have tried all the thing but nothing seems to be Working for us.
We are having Go-Live very soon please provide some reosultion

[Mira]

Hello Manishkumar,

I have answered your post about the same issue in the GridDateTimeColumn "Equal To" filter problem forum thread.
In order to avoid duplicate posts, I suggest that we continue the communication in it.

Best wishes,
Mira
the Telerik team