by IanRTaylorUK » Sun Apr 12, 2026 4:01 am
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.
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.