[REQ] Dynamic Playlist on Date

[pkohn11]

Hi - I'm wondering if there's a way to do a dynamic date field as a filter for playlists. For example, If I want music within the last 10 years without having to adjust the date all the time.

Currently I can set if the date is >= 2016

Ideally I can say date is within the last 10 years.

[Lowlander]

No, this isn't possible.

[pkohn11]

Thank you for confirming. Is "Beta testing, bugs, and feature requests - MMW 2024" still the best place to put in feature requests?

[Lowlander]

Yes

[IanRTaylorUK]

Use the Custom Nodes Add-On.

Add a "Track" type query using Configure Custom Nodes called "Rolling 10 Years"

Then an SQL query something like:

SELECT * FROM Songs WHERE
CAST( substr( Year,1,4 ) AS INTEGER )
BEWEEN ( CAST ( strftime ( '%Y' , 'now' ) AS INTEGER ) -9 )
AND CAST ( CAST ( strftime ( '%Y' , 'now' ) AS INTEGER )
AND TrackType = 0

If you want a Playlist, then use CTRL+A to select ALL and then right click / send to / Playlist / New Playlist.

[rusty]

Good idea!

-Rusty