INTERACT FORUM

More => Old Versions => JRiver Media Center 20 for Windows => Topic started by: darichman on June 07, 2015, 09:46:47 pm

Title: Date Expression Help
Post by: darichman on June 07, 2015, 09:46:47 pm

I'm trying to rewrite my photo handling expressions to make use of date parameters in the file structure:
  If [date] is 13/2/2014 I want the output file structure to be 2014/2014.02

How can I output the month to a number (ie February = 2)

I've tried =[date (month)]&DataType=[Integer]
and =[date (month)]&DataType=[Number]

But it always just outputs "February" or "March" etc.

I tend to just fumble around with expressions and through some combination of trial & error and luck I usually get there in the end :) but I can't figure this one out. Any help greatly appreciated!

Title: Re: Date Expression Help
Post by: blgentry on June 07, 2015, 10:14:30 pm

You almost certainly want to use the FormatDate() function.  If your example is literally true... that is, you want to take something like:

6/6/2015 and turn it into:  2015/2015.06

...then here's the expression to do it:

formatdate(%Y//%Y.%m)

Here are the full docs on it:

http://wiki.jriver.com/index.php/Expression_Language#FormatDate (http://wiki.jriver.com/index.php/Expression_Language#FormatDate)

Brian.

Title: Re: Date Expression Help
Post by: darichman on June 09, 2015, 07:10:16 pm

Thanks so much Brian - appreciate it :)