Print

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

[AndromAK]

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?

[Matt]

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

[AndromAK]

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

[Matt]

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.

[AndromAK]

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

[Matt]

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)