INTERACT FORUM

Please login or register.

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

Author Topic: Last Played n days ago  (Read 2094 times)

newHAPPYuser2015

  • World Citizen
  • ***
  • Posts: 111
Last Played n days ago
« on: September 16, 2015, 02:41:20 pm »

In tagging window it shows last played date for a song as 19,3 days ago for example. Is it possible to create a column that would show last played date in this format - last played n days ago, not just a date like default 'last played' field?

Thanks
Logged

Matt

  • Administrator
  • Citizen of the Universe
  • *****
  • Posts: 42374
  • Shoes gone again!
Re: Last Played n days ago
« Reply #1 on: September 16, 2015, 02:48:52 pm »

Here's a start (it's an expression, so make an expression column):
FormatDate([Last Played, 0],elapsed) ago
Logged
Matt Ashland, JRiver Media Center

newHAPPYuser2015

  • World Citizen
  • ***
  • Posts: 111
Re: Last Played n days ago
« Reply #2 on: September 16, 2015, 03:07:00 pm »

Thanks. Rounded it to whole days
FormatDate([Last Played, 0], d, elapsed) days ago

FormatDate([Last Played, 0],elapsed) ago is a bit too precise for my taste - it shows time right down to seconds for some songs and updates every few seconds, for example ''6:26:28 ago''. Looks kinda funny.
Logged
Pages: [1]   Go Up