Grouping with the "Date" part of "DateTime"

[Gregor Daskaloff]

Hi,

is it possible to group a DateTime property only with the DatTime.Date part?
I get an object with the property "Beginning" of type DateTime from Database. But I want to group only the "Day" (DateTime.Date) part, because there are diefferent times.

<GroupByExpressions>
 <telerik:GridGroupByExpression>
  <SelectFields>
   <telerik:GridGroupByField HeaderValueSeparator=" am: " FieldName="Beginning"
                             FormatString="{0:dddd, dd MMMM yyyy}"
                             FieldAlias="Date" />
  </SelectFields>
  <GroupByFields>
   <telerik:GridGroupByField FieldName="Beginning" SortOrder="Descending" />
  </GroupByFields>
 </telerik:GridGroupByExpression>
</GroupByExpressions>

But I get an output likes this:

http://s5.directupload.net/images/101123/agcdauma.png

The 31. December is splittet into two groups, because of the different times, but I want one single group of 31. December.

Thanks in advance.

Gregor D.

[Veli]

Hello Gregor,

You need to have a field in your data items that will return your Date values without the time portion. This way RadGrid can group by that field. Otherwise, you cannot modify the values RadGrid uses for grouping your data.

Regards,
Veli
the Telerik team