SSRS Date column sorting

Question

I have a SSRS 2008 R2 tablix which displays like this :

 _____________________________
|               |    Date     |
|_____________________________|
|     Row1      |             |
|     Row2      |             |     
|     Row3      |             |
|_______________|_____________| 

The Date displays data in YYYY/mmm format (2015/01 , 2015/02, 2015/03). This column has a grouping on it (column group).

The current sorting sorts the dates incorrectly (2015/1 , 2015/10 , 2015/11)

I have tried sorting by adding a sorting option in the Tablix Properties (AtoZ) but this doesn't work.

Any help would be greatly appreciated.

Answer 1

Your dates are probably stored as strings.

So convert them to date

CAST(yourDateString AS DATE)

Answer 2

You can apply conversion in sorting expression. Try to use:

=CDate(Fields!DateString.Value)