Get the month from vbld_FormatDateEx

[mptorney]

I'm in the UK, so my date format has the day first, so today (Feb 1st) is written as 01/02/2012. When I use vbld_FormatDateEx to get the month back, I don't get the correct result. For example, if

COMMITDATE = 01/02/2012 16:29:42

and I call [vbld_FormatDateEx("%COMMITDATE%", "mm")]

the result is 01, not 02. I though I could get around this by using "dd", which returns the correct result for the first 12 days of the month (while there is an ambiguity, I guess), and the actual day for the rest of the month.

Am I missing something? Can I force the date format that's used? Or should I just parse COMMITDATE myself?

[kinook]

Currently, Visual Build always uses US English locale for the script engine, so conversion of a string to a date in script code will parse with US English formatting. In the future, we will provide a way to use the current locale for script code, but for now you would need to parse the month out manually. One way would be:
[Split("%COMMITDATE%", "/")(1)]

[kinook]

This is supported in v8.0.