INTERACT FORUM

More => Old Versions => JRiver Media Center 30 for Windows => Topic started by: Wilhelm Kabus on February 17, 2023, 11:07:18 am

Title: Convertdate
Post by: Wilhelm Kabus on February 17, 2023, 11:07:18 am
Hi! In this version my expression column formula no longer works. Displaying "Expression Error":

s-math(
FormatNumber( Now(),0)
-
FormatNumber( ConvertDate([played],0)))

Used to give me # of days since last played :-)
Title: Re: Convertdate
Post by: Matt on February 17, 2023, 11:38:38 am
Hi! In this version my expression column formula no longer works. Displaying "Expression Error":

s-math(
FormatNumber( Now(),0)
-
FormatNumber( ConvertDate([played],0)))

Used to give me # of days since last played :-)

I think your date is already the internal format so doing ConvertDate won't work.

Maybe something like this:
CompareDates([Last Played, 0], Now(), d)
Title: Re: Convertdate
Post by: Wilhelm Kabus on February 17, 2023, 12:46:02 pm
I think your date is already the internal format so doing ConvertDate won't work.

Maybe something like this:
CompareDates([Last Played, 0], Now(), d)

But it worked fine in many previous versions. You don't want to support my formula anymore, Matt?
Title: Re: Convertdate
Post by: Matt on February 17, 2023, 12:54:35 pm
But it worked fine in many previous versions. You don't want to support my formula anymore, Matt?

It's just because there are a couple parameters to the ConverDate function but it only takes one.  I can switch to just ignoring the extra parameters in the next build.
Title: Re: Convertdate
Post by: zybex on February 17, 2023, 01:58:20 pm
Maybe you meant ConvertDate([played,0])) ?

ConvertDate([played],0)) is wrong and was always wrong - it just worked because the second argument (0) was ignored, which is no longer the case.
Title: Re: Convertdate
Post by: Wilhelm Kabus on February 17, 2023, 05:34:35 pm
No need, Matt... I removed it. Works now...