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"

* 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/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