INTERACT FORUM
More => Old Versions => JRiver Media Center 24 for Windows => Topic started by: maliceme on June 14, 2018, 11:32:07 am
-
Looking for help creating a smartlist. I have a custom date field called "recording date" that follows the standard mm/dd/yyyy format. I'd like to create a smartlist that filters for albums where the recording date mm/dd matches the current mm/dd values. Thanks!
-
Was the field created as a date?
If it was, you can just create a smartlist and say that date must be equal some date value (like 6/14/2018).
You can also say "is in the range" and enter a start and end date.
-
Matt - Thanks for the quick response. Yes, the Recorded Date is a date field. What I am looking for is a dynamic smartlist that will look at the current date (e.g., 06/14/2018) and return all albums with a Recorded Date of 06/14/YYYY.
-
Just for you, next build will have this:
NEW: Added a DateInRange expression function that takes a date, a start date, and an end date and says whether the date is in the range.
This way you can create an expression like:
DateInRange([My Date], FormatDate(Now(), MM-dd-yyyy), FormatDate(Math(Now() + 1), MM-dd-yyyy))
And it will find all the files dated today or the next day.
-
Muchas gracias!
-
Could be handy, cheers.
I worked on whole heap of "When In Time" smartlists a couple of years ago that work well in a "Search List" type pane. If curious, you can check them out at the link below, which has a jvi view file attached for convenience.
https://yabb.jriver.com/interact/index.php/topic,102478.0.html
-marko