Print

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

[maliceme]

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!

[Matt]

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.

[maliceme]

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.

[Matt]

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.

[maliceme]

Muchas gracias!

[marko]

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