Grouping on month,Year

leif · Post by **leif** » Mon Dec 31, 2007 9:37 am

I have records containing dates in dd.MMM.YYYY format, and I want to group on month,year. How ??

Kind regards

Leif Linding
ScanCad

Happy New Year to all of you!

Post by **Vital** » Mon Dec 31, 2007 12:45 pm

Dates stored in your database as strings?

Thank you.

leif · Post by **leif** » Tue Jan 01, 2008 8:04 am

Vital wrote:Dates stored in your database as strings?

Thank you.

No as dates

leif · Post by **leif** » Tue Jan 01, 2008 8:06 am

No as dates

Post by **Vital** » Tue Jan 01, 2008 12:45 pm

Please use following expression in condition of group:

Code: Select all

{datasource.column.ToString("MM.yyyy")}

Thank you.