Formats

FlowScript supports converting numeric values and date times to string with a provided format string. This is performed with the format function.

Numeric values

Format

Description

Example (value: 1234.567)

Example Result

"C"

A currency value.*

"C" (en-US) "C" (sv-SE)

"$1,234.57" "1.234,57 kr"

"F"

Integral and decimal digits with optional negative sign.*

"F" (en-US) "F" (de-DE)

"1234.57" "1234,57"

"Fn" (ex "F1")

Same as "F" with n precision (Number of decimal digits.)*

"F1" (en-US) "F3" (de-DE)

"1234.6" "1234,567"

"N"

Integral and decimal digits, group separators, and a decimal separator with optional negative sign.*

"N" (en-US) "N" (ru-RU)

"1,234.57" "1 234,57"

"Nn" (ex "N1")

Same as "N" with n precision (Number of decimal digits.)*

"N1" (en-US) "N3" (ru-RU)

"1,234.6" "1 234,567"

* The result is formatted based on the locale of the computer where the Flow Engine is executing. Some FlowScript functions support overriding the locale.

Read more about .NET Date and Time format strings here: http://msdn.microsoft.com/en-us/library/dwhawy9k.aspx

Date and time format

Format

Description

Example (date: 2009-06-15T13:45:30)

Example Result

"d"

The day of the month, from 1 through 31.

"d"

"15"

"dd"

The day of the month, from 01 through 31.

"dd"

"15"

"dddd"

The full name of the day of the week.*

"dddd" (en-US)

"Monday"

"M"

The month, from 1 through 12.

"M"

"6"

"MM"

The month, from 01 through 12.

"MM"

"06"

"MMM"

The abbreviated name of the month.*

"MMM" (en-US)

"Jun"

"MMMM"

The full name of the month.*

"MMMM" (en-US)

"June"

"yy"

The year, from 00 to 99.

"yy"

"09"

"yyyy"

The year as a four-digit number.

"yyyy"

"2009"

":"

The time separator.*

"HH:mm" (en-US) "HH:mm" (ar-DZ)

"13:45" "13.45"

"/"

The date separator.*

"yy/MM/dd" (en-US) "yy/MM/dd" (ar-DZ)

"09/06/15" "09-06-15"

"\"

The escape character.

"\M M"

"M 6"

* Language/format is defined by the computer where the Flow Engine is executing.

Read more about .NET Date and Time format strings here: http://msdn.microsoft.com/en-us/library/8kb3ddd4.aspx

Last updated