Print

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

[NZsMikeBerry]

I'm successfully using Media Center Automation Objects in Excel VB with one exception;

I can't seem to access (Read Or Write) the MJFileAutomation "Year" Property       (http://wiki.jriver.com/index.php/MJFileAutomation)

No problem with any other Properties eg

lLong = mcFAo.Get("Rating", False)
lResult = mcFAo.Set("Rating", 4)

both work fine, but

lLong = mcFAo.Get("Year", False) which should be the correct syntax gives a Compile Error

and

lString = mcFAo.Get("Year", False) compiles OK, but doesn't return a value

The Format parameter doesn't seem to make any difference either

Any clues?

[Matt]

Year isn't a field in current versions of Media Center.

The only field is "Date", which can contain a year or a year with day and time.

You can also use the calculated field "Date (year)" which maps back to "Date".

[NZsMikeBerry]

MJFileAutomation
   2 Properties

number Year() (read / write)
Description: the year (i.e. 1997)

Thanks for your reply and will probably spend June 2011 decoding the Sticky Date

New Stitch;

Media Center Expression Language

Filtering a list of files using a search rule;

1)   [=Left([Comment],2)]="30"             works fine
2)   [=IsRange([Comment],29-31)]=1     works fine

3) subs 1) into 2)

[=IsRange([=Left([Comment],2)],29-31)]=1    no worky,

and all other combo's of [,=,(," that I've tried also seem to fail

Nesting is allowed according to MJ Documentation, but the devil is in the (poorly-documentaed) detail