Print

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

[darichman]

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!

[blgentry]

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

Brian.

[darichman]

Thanks so much Brian - appreciate it