Filter doesn't work with GridDateTimeColumn

[Elliott]

I have a grid using a GridDateTimeColumn formatted from a stored procedure as mm/dd/yyyy.  The textbox alongside the DatePicker to filter zero supresses in the month and day so Equal To filtering doesn't work.  How do I fix this?

<telerik:GridDateTimeColumn UniqueName="ShipDate" DataField="ShipDate" PickerType="DatePicker" HeaderText="Ship Date" DataFormatString="{0:D}" CurrentFilterFunction="EqualTo" DataType="System.DateTime" FilterListOptions="VaryByDataType" >
</telerik:GridDateTimeColumn>

SELECT StoreNumber,
       AO.BoothNumber,
       AO.ItemID,
       ItemDescription,
       CONVERT(VARCHAR,ShipDate,101) AS ShipDate, .....

[Maria Ilieva]

Hello Marianne,

Note that when the ShipDate is convert to VARCHAR this is interpreted as string in C# and the column will be filtered by string and not by Date. Also please let me know if you set DataFormatString to mm/dd/yyyy the same problematic behavior appear. Please refer to the following help topic for additional information on similar scenarios:
http://www.telerik.com/help/aspnet-ajax/grid-filtering-for-griddatetimecolumn-with-dataformatstring.html



Best wishes,
Maria Ilieva
the Telerik team

[Elliott]

thanks!