Format

Use the Duration format to format the display of numerical data as a duration of time, such as 4 Days and 17 Hours.

The Convert From takes a number and formats it according to what you specify. Convert From options include:

• Milliseconds
• Seconds
• Minutes
• Hours

The available duration formats include:

• Time Span (00:00:00)
• Friendly Short Units (h, m, s)
• Friendly Medium Units (Hrs, Mins, Secs)
• Friendly Long Units (Hours, Minutes, Seconds)

The following controls support the duration format:

• Data Label
• Label
• Text Box
• Text Area

Configuring the Control with Duration Format

The following is an example of how to use the Duration format on a control.

1. Add a text box control to a view.
2. Select the control and then click the ellipses (...) next to the Format property as shown below.
   
3. On the Format page, select the Duration option on the Format tab. Choose a Convert From and Format option. This example uses Minutes and Friendly Short Units.
   
4. Click OK, then Save and Finish the view.
5. Run the view.
6. Enter a number value in the text box.
   
7. The numerical value changes to the Duration format.
   

Considerations

• You can only format whole numbers.
• If you enter a value that is not a number, the value is ignored.
• The list of Duration formats depends on the browser culture (User settings) or the selected culture (Use option) you configure as the Language/Region.

Use the Special format to format numbers as shown in the image below.

Four default special formats are available for the English (United States) culture:

• Phone Number
• Social Security Number
• Zip code
• Zip code + 4

Examples

The following examples indicate how the patterns apply to the text entered in runtime:

Text entered	Pattern	Result
Phone Number
1234567890	(###) ###-####	(123) 456-7890
Social Security Number
123456789	###-##-####	123-45-6789
Zip code
12345	#####	12345
Zip code + 4
123456789	#####-####	12345-6789

Creating Custom Special Formats

You can also create a custom special format. See the following link in the Developer Reference for more detail: Adding and Using a Custom Special Format

Considerations

The following principles apply when you use Special formatting:

• Formatting applies to numbers that you enter into the control at runtime.
• If you enter a value that is not a number, the value is ignored.
• A “#” in the pattern is replaced with the number corresponding to the position in the value that you enter.
• When you use another symbol or character in the pattern, they appear in the result.
• A 0 (zero) in the pattern represents either the number corresponding to the position in the value that you enter, or pads the result. For example, if you specify a 4 digit number and your pattern is five zeros (00000), the result starts with a zero followed by the 4 digit number.
• The list of Special formats depends on the browser culture (User settings) or the selected culture (Use option) you configure as the Language/Region.
• The pattern applies to the display at runtime, the underlying value remains the same as what you enter.