Sort Datetime

[#1]

Hello,

There is a date field, loaded in the format YYYYMMDDHHmmSS

I am using this field in a drilldown group as dimension to display month, week and day

Expressions used are

=month(date#(Mid([datefield],1,8),'YYYYMMDD'))  

=Week(date#(Mid([datefield],1,8), 'YYYYMMDD'))

= date(date#(Mid([datefield],1,8), 'YYYYMMDD'),'MM/DD/YYYY')

There is data from Oct 2014 to Jan 2015,

currently I am sorting with numeric option, so it displays Jan first. (Jan, Oct, Nov, Dec)

But actually I want to sort it in below order

Oct

Nov

Dec

Jan

Please suggest how can I do this.

Thanks,

Deepa

[ecolomer]

You can use to sort by month:

Num(Month(date#(Mid([datefield],1,8),'YYYYMMDD')), '00')

[v_iyyappan]

Hi Deepa,

Please find the attached file.

Hope it will help to you.

Regards,