INTERACT FORUM

Please login or register.

Login with username, password and session length
Advanced search  
Pages: [1]   Go Down

Author Topic: Smartlist "On This Date"  (Read 757 times)

maliceme

  • Junior Woodchuck
  • **
  • Posts: 96
Smartlist "On This Date"
« 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!
Logged

Matt

  • Administrator
  • Citizen of the Universe
  • *****
  • Posts: 42323
  • Shoes gone again!
Re: Smartlist "On This Date"
« Reply #1 on: June 14, 2018, 11:53:39 am »

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.
Logged
Matt Ashland, JRiver Media Center

maliceme

  • Junior Woodchuck
  • **
  • Posts: 96
Re: Smartlist "On This Date"
« Reply #2 on: June 14, 2018, 11:58:36 am »

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.
Logged

Matt

  • Administrator
  • Citizen of the Universe
  • *****
  • Posts: 42323
  • Shoes gone again!
Re: Smartlist "On This Date"
« Reply #3 on: June 14, 2018, 01:16:42 pm »

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.
Logged
Matt Ashland, JRiver Media Center

maliceme

  • Junior Woodchuck
  • **
  • Posts: 96
Re: Smartlist "On This Date"
« Reply #4 on: June 14, 2018, 01:42:56 pm »

Muchas gracias!
Logged

marko

  • MC Beta Team
  • Citizen of the Universe
  • *****
  • Posts: 9124
Re: Smartlist "On This Date"
« Reply #5 on: June 14, 2018, 02:18:51 pm »

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
Pages: [1]   Go Up