Print

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

[bennyd]

I'm looking for a way to build a smartlist that shows the [last played] before a certain date.

So eg. show me all songs last played before 2005/01/18

I tried the following expression:

FormatDate([Last Played,0],yyyyMMdd)&DataType=[Number] <= 20050118

but this shows me no results

Anyone could help ?

[Mr ChriZ]

I think I understand why it doesn't work..
Is there a way to get the current system date?

-Additional Note,
Did some forum searching..
I think I'm late to a tea party here...

*Sips tea*
Yup I'm gonna leave this to the clever people.

[Alex B]

It seems that MC's calendar starts from January 1st 1970, 2:00 am. Internally MC counts seconds so the search expression would be:
[Last Played]=<1105999200

Easy as pie, isn't it. 

(I don't know if MC accepts any other time format. If it doesn't, a usable date format should be added.)

[bennyd]

Thanks for the replies,

Matt, isn't there any easier way so we can choose the format to search by in stead of seconds ?

The reason why I ask this is the following:
 - I sync 500 songs on my iPod from a Smartlist
- That smartlist should show me all songs not played since the date I synced with my iPod
- When I sync again, it should update the smartlist so it filters out all the files that have been played on my iPod
- Then the smartlist on my iPod will contain only the songs that haven't been played yet since I synced


Any way to do this fairly easy without counting seconds ?

[bennyd]

nobody ?

[bennyd]

bump