INTERACT FORUM

More => Old Versions => Media Center 11 (Development Ended) => Topic started by: bennyd on January 19, 2006, 03:52:23 pm

Title: [Last Played] challenge
Post by: bennyd on January 19, 2006, 03:52:23 pm
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 ?
Title: Re: [Last Played] challenge
Post by: Mr ChriZ on January 19, 2006, 08:20:07 pm
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.
Title: Re: [Last Played] challenge
Post by: Alex B on January 19, 2006, 10:37:30 pm
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.)
Title: Re: [Last Played] challenge
Post by: bennyd on January 20, 2006, 02:37:29 am
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 ?

Title: Re: [Last Played] challenge
Post by: bennyd on January 26, 2006, 01:13:15 am
nobody ?
Title: Re: [Last Played] challenge
Post by: bennyd on January 30, 2006, 09:30:00 am
bump