Hi,
I'm using RadGrid and FilterTemplates in order to have a range of dates. When the user select from date "01/01/2012" and to date "10/01/2012" this filter all records that were made during that range of time. however, is excluding all those transaction that occurred the First and the tenth.
http://demos.telerik.com/aspnet-ajax/grid/examples/programming/filtertemplate/defaultcs.aspx (Based on this sample)
I have defined DateFormatString as "MM/dd/yyyy" and is still excluding records. My query return datetime types meaning that the Date field is return date and time.
So how can I tried to convert them into string but is not filter correctly because it doesn't filter the year only days and months.
SO I would really appreciate your help or advice in this matter. Because I want to include those record that were made on January First and in the Tenth.
I'm using RadGrid and FilterTemplates in order to have a range of dates. When the user select from date "01/01/2012" and to date "10/01/2012" this filter all records that were made during that range of time. however, is excluding all those transaction that occurred the First and the tenth.
http://demos.telerik.com/aspnet-ajax/grid/examples/programming/filtertemplate/defaultcs.aspx (Based on this sample)
I have defined DateFormatString as "MM/dd/yyyy" and is still excluding records. My query return datetime types meaning that the Date field is return date and time.
So how can I tried to convert them into string but is not filter correctly because it doesn't filter the year only days and months.
SO I would really appreciate your help or advice in this matter. Because I want to include those record that were made on January First and in the Tenth.
1 Answer, 1 is accepted
0
Victor
Top achievements
Rank 1
Rank 1
answered on 30 Mar 2012, 12:35 AM
I fixed by setting the dateformat to "yyyy/MM/ddd"