Topic: Expression question (Read 991 times)

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?

marko · « **Reply #1 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.

c1c9k72 · « **Reply #2 on:** June 21, 2007, 05:52:44 am »

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

INTERACT FORUM

Author Topic: Expression question (Read 991 times)

c1c9k72

Expression question

marko

Re: Expression question

c1c9k72

Re: Expression question