Formats
Last updated
Was this helpful?
Last updated
Was this helpful?
FlowScript supports converting numeric values and date times to string with a provided format string. This is performed with the format function.
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:
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: