Kinook Software Forum

Kinook Software Forum (https://www.kinook.com/Forum/index.php)
-   [VBP] General Discussion (https://www.kinook.com/Forum/forumdisplay.php?f=2)
-   -   Get the month from vbld_FormatDateEx (https://www.kinook.com/Forum/showthread.php?t=4955)

mptorney 02-01-2012 10:59 AM

Get the month from vbld_FormatDateEx
 
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 02-01-2012 03:09 PM

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:
Code:

[Split("%COMMITDATE%", "/")(1)]

kinook 02-24-2012 08:21 AM

This is supported in v8.0.


All times are GMT -5. The time now is 03:12 AM.


Copyright © 1999-2023 Kinook Software, Inc.