Print

Please login or register.
1 Hour 1 Day 1 Week 1 Month Forever
Login with username, password and session length

[stevenf]

I created a new field simply called "played" and added in the calculated field this expression

FormatDate ([Last Played, 0], dd//MM//yyyy). However, the field does not sort in order, what i get is this...

01/02/2004
01/02/2005
01/02/2005
01/03/2005
01/03/2005
01/03/2005
01/04/2006
01/04/2003

And so on, the day is sorted first, then the month and then the year.

Is there anyway i can sort the field the way that is supposed to.

19/02/2003
19/02/2003
27/02/2003
27/02/2003
28/02/2003
01/03/2003

And so on

Any help would be greatly appreciated.

Stevef

[marko]

change the template to year/month/day

formatdate([last played,0],yyyy//MM//dd)

[stevenf]

Did that, the only problem is that it now shows this,

2006/03/27 amd what it want is 27/03/2006 in order

thanks

[Marty3d]

Sorry to say, the above way is the only way. MC has no option to sort dates properly, just by "string". I encountered this when I wanted to sort Last Played dates formatted "3 days ago", "3 years ago". <- Guess what came first in that list

/Martin

[PollyQ]

Use two date fields, one for sorting (yyyy/mm/dd) and one for display (mm/dd/yyyy or whatever).

[marko]

Polly, sorting in the filelist is not a problem. In the file list, you would simply apply a [last played] sort rule and the dates would be in order.

There's no way to control sorting in the panes.

[stevenf]

Marko, how that be done, coding of any sort is not my strong point

Stevenf

[marko]

Stevenf,

If you right click in the file list, then choose 'customise current view' you will be presented with these options:



The section in the lower-right deals with sorting. Click the 'Add' button, decide whether you want descending or ascending sorting, then pick Last Played from the list.
once it's added, click on it, and move it to the top, then click the OK button.

Hopefully that will give you the result you're after, but, again, I'll draw your attention to the fact that the subject is number plays, but here, we're discussing Last Played ....

[stevenf]

Unfortunatly that's not really what i'm after. As you can see from the image, it's the pane view where i want last played to sort in descending order. In the picture, it's the first song played, and i want the lastest songs at the top.



I appreciate any help i can get. Thanks

Stevenf

[marko]

Polly, sorting in the filelist is not a problem. In the file list, you would simply apply a [last played] sort rule and the dates would be in order.

There's no way to control sorting in the panes.