Skip to main content
Announcements
Marching toward a simplified navigation! READ ON
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Sort Datetime


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

11 Replies
ecolomer
Master II
Master II

You can use to sort by month:

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

v_iyyappan
Specialist
Specialist

Hi Deepa,

Please find the attached file.

Hope it will help to you.

Regards,