INTERACT FORUM

More => Old Versions => Media Center 12 (Development Ended) => Topic started by: c1c9k72 on June 20, 2007, 05:54:48 pm

Title: Expression question
Post by: c1c9k72 on June 20, 2007, 05:54:48 pm

Ok, I have this expression called [AGE].  It's defined as the following: =FormatNumber(Formatdate([Date Imported, 0]))

And it works great for what it's used for.  The problem is that I have about 300 files which return a result of '0'.  And, I noticed that it's songs/files without a [DATE] entry where this happens.  My question is: Why?  Date isn't being affected, only the Date Imported.

Any suggestions?

Title: Re: Expression question
Post by: marko on June 21, 2007, 05:44:58 am

I'm not sure why exactly, maybe syntax error? Using 'formatdate', you're asking the expression evaluator to format the raw [date imported] data, but not telling it how you want the data to be formatted.

=FormatNumber([Date Imported, 0]) appears to work just fine on files with or without dates.

-marko.

Title: Re: Expression question
Post by: c1c9k72 on June 21, 2007, 05:52:44 am

Thanks, Marko.  That seems to have taken care of it.