Print

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

[Ferdi]

I'd like to have a playlist that shows me music that I have imported during the last x number of days.

An expression could be "today minus date imported greater than x",  and i found out that these components could be used:

• now() gives me the current date in numeric value
• ConvertDate([Date Imported]) converts the import date into numeric value

I fail to turn that into a correct expression though, don't know how to subtract, which I thought would be the most simple part of this!

Appreciate any help. cheers.

[ferday]

if you use convertdate() it will turn a readable date into the computerized big number, but then you should be able to do a simple math

math(convertdate(now())-convertdate([date(imported)]))

or something close to that, no chance to test ATM

[Ferdi]

Thanks for the super quick reply!
I needed to slightly modify to: Math(now() - ConvertDate([Date Imported])). 
When using this as a new field and displaying this field, I noticed that the value is updated almost constantly. Reason is that 'now' goes by seconds...

So next I tried to format that output into 'days', and actually saw that for the for the formula formatdate, this example is given: FormatDate([Date Imported, 0], elapsed) .
Pretty nifty. I'll start playing around with this, as it's not perfect either when used in a playlist, since the values are now hard to compare.

Anyway, I now got two ideas that I can play with, will keep me busy for a while I think

[ferday]

in a smartlist you can also use

[date (imported)]=<Xd

as a search string (X is the number)

[marko]

Might be something here you could find useful too..

http://yabb.jriver.com/interact/index.php?topic=102319.msg709847#msg709847

[Ferdi]

Thanks - that's brilliant information on there. Looking forward to free time on the weekend