INTERACT FORUM

More => Old Versions => Media Center 11 (Development Ended) => Topic started by: AndromAK on March 15, 2005, 01:52:42 pm

Title: new expression evaluator
Post by: AndromAK on March 15, 2005, 01:52:42 pm

I have some problem with the new released 11.0.214

in a View Scheme,

([Date (year)])   [Album]
doesn't work anymore, and shows
([Date (year)])   Abbey Road, for example

in another one,

[last played]:date(yyyy/MM/dd)
shows
38320,73777777778:date(yyyy/MM/dd)

How can I fix that with the new expression evaluator?

Title: Re: new expression evaluator
Post by: Matt on March 15, 2005, 01:55:26 pm

MC 11.0.214 has a bug with field names that have parenthesis.  It'll be fixed tonight.

Your other expression uses the old style that's not supported now.  To format as a date, do this:

FormatDate([Last Played],yyyy/MM/dd)

There's documentation here:
http://www.jrmediacenter.com/DevZone/DBExpressions.htm

Title: Re: new expression evaluator
Post by: AndromAK on March 15, 2005, 02:17:18 pm

Thank you for your quick answer!!

I noticed that:

FormatDate([Last Played],yyyy//MM//dd)
shows:
2005/03/15

rather than

FormatDate([Last Played],yyyy/MM/dd)
that shows:
20050315

Title: Re: new expression evaluator
Post by: Matt on March 15, 2005, 02:27:39 pm

Slash is the 'escape' character.  It allows, for example, something like this:
If(1, I actually want a comma here: /,, hopefully it understands I'm only the third parameter/, not the fourth)

So anyway, you need two slashes together to get an actual slash.

Title: Re: new expression evaluator
Post by: AndromAK on March 16, 2005, 09:30:07 am

I noticed that the expression
FormatDate([Last Played],yyyy//MM//dd)
returns
1970/01/01
when the track hasn't been played.

So I improved the expression for those who are interested :

If(IsEqual([Number Plays], 0,2), no date, FormatDate([Last Played],yyyy//MM//dd) )

It now returns "no date" instead of "1970/01/01"

I hope it will be usefull for some people...

Title: Re: new expression evaluator
Post by: Matt on March 16, 2005, 10:59:03 am

Next build, you can change:

If(IsEqual([Number Plays], 0,2), no date, FormatDate([Last Played],yyyy//MM//dd) )

to

FormatDate([Last Played], yyyy//MM//dd, no date)