Hi,
I have a date column and sort by desc is not working. In addition, I have Max functions implemented in other columns in the table.
How can I sort the date column by Desc? Any work around, please let know.
Thanks…
JohnJustus 
(BOB member since 2007-06-25)
I found out the reason,
Once I insert a Break to another column in the table then the Date column is going out of order and not coming back even though I sort by desc again.
Does anyone know how to make the Date column in Desc order. The date format is MM/dd/yyyy
Thanks…
JohnJustus (BOB member since 2007-06-25)
Which is more important? To Break on an object, you need to sort by it, so the break will override the sort. The sort may still happen, just not in the order you expect.
You may be able to emulate what you’re looking for with multiple Breaks, or compound breaks. Play around with editing the breaks (and seeing that you can select more than a single field to break on).
digpen (BOB member since 2002-08-15)
I am not applying the break where sort is required. I am applying break on another object. So the break and sort should work correct in this case?
Anyway, I am playing around with the breaks.
Thanks…
JohnJustus (BOB member since 2007-06-25)
I have seen some “funky” things with the Date column not sorting in descending order properly when the field is left as a date. Can you create a “string” version of the date and sort by that?
Date2OrderBy
=FormatDate( <DateObject>, "YYYYMMDD" )That should sort correctly in both ascending and descending order.[/b]
digpen (BOB member since 2002-08-15)
Thanks…
Actually the whole morning session I searched in the Forum and I tried all the workaround(s) and nothing seems to be working and even I tried the one you have mentioned here.
As soon as I apply the break on the next column to the Date column ,the sorting order of the date collapses. I tried with multiple break’s, removing the like break values and all other tricks - nothing works out.
Any other ideas, please let me know and I can give it a try.
Thanks…
JohnJustus (BOB member since 2007-06-25)
I noticed you said your “Date Format” was MM/DD/YYYY. Are you doing a “FormatDate()” function to your date, or did you just format your Cell as a date format of: mm/dd/yyyy ?
There is a difference. The FormatDate() converts the date to a character string which will alphanumerically sort with the years out of sync.
That’s also the only way I’ve been able to reproduce the behavior you listed here.
digpen (BOB member since 2002-08-15)
Hi,
I am not doing any format in the report. The date comes as is from the universe in the format of mm/dd/yyyy and then I converted that date object in to one as below and applied sort but isnt working.
=FormatDate( , “YYYYMMDD” )
Thanks…
JohnJustus (BOB member since 2007-06-25)