Print

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

[winterminute]

I'm trying to create a playlist which has the last 200 tracks imported with a certain rating.  The rating part is easy and I found some posts which highlight the fact that [Date Imported] is really a datetime stamp and can't be used for sort purposes so I created a new calculated field with this formula:

     formatdate([date imported,0],yyyy//MM//dd)

If I create a playlist with just my rating criteria and use the newly column header to sort, then I see all the tracks I recently imported that I expect to be there.  For example, I see 105 tracks added since Dec 1st with a rating of 4 or higher.  However, as soon as I add a Limited Number To=200, then most new tracks disappear and I end up with older tracks from months ago.  In this case, I only see 9 tracks added since Dec 1st with a rating of 4 or higher.

So, it definitely seems to be the sorting logic, but I don't fully understand why.
Here are the modifiers:
   Sort By             = ~sort=[Import Date] -d
   Limit Number To  = 200

Any ideas?

[marko]

Check this first: ~sort=[Import Date] -d

There should not be a space between the field and the 'descending' instruction.

~sort=[Import Date]-d

If it's not as simple as that, shout back and we'll get it sorted.

-marko.