Format Mask Examples

Format masks need to be created before numeric, date, date and time, and currency fields can be assigned format masks.  The following examples include how to create a format mask for each of these types.

See Also

Format Masks

Creating Date Format Masks

1. Left click on the Format Mask Information object in the Explorer Tree to select it.

2. Right click on the Format Mask Information object and select Create Format Mask from the menu.
   

3. The Creating Format Mask screen is displayed.

4. Set the Data Type pop-list to Date (only).

5. In the Format Mask field, enter MM-dd-yyyy.
   

6. Click on the Create button to create the format mask.

7. Press the Save button in the main toolbar to save the new format mask.

Creating Date/Time Format Masks

1. Left click on the Format Mask Information object in the Explorer Tree to select it.

2. Right click on the Format Mask Information object and select Create Format Mask from the menu.
   

3. The Creating Format Mask screen is displayed.

4. Set the Data Type pop-list to Date and Time.

5. In the Format Mask field, enter MM-dd-yyyy HH:mm
   

6. Click on the Create button to create the format mask.

7. Press the Save button in the main toolbar to save the new format mask.

Creating Numeric Format Masks

1. Left click on the Format Mask Information object in the Explorer Tree to select it.

2. Right click on the Format Mask Information object and select Create Format Mask from the menu.
   

3. The Creating Format Mask screen is displayed.

4. Set the Data Type pop-list to Numeric.

5. In the Format Mask field, enter #,###,###.00.
   

6. Click on the Create button to create the format mask.

7. Press the Save button in the main toolbar to save the new format mask.

Creating Currency Format Masks

1. Left click on the Format Mask Information object in the Explorer Tree to select it.

2. Right click on the Format Mask Information object and select Create Format Mask from the menu.
   

3. The Creating Format Mask screen is displayed.

4. Set the Data Type pop-list to Currency.

5. In the Format Mask field, enter #,###,###.00.
   

6. Click on the Create button to create the format mask.

7. Press the Save button in the main toolbar to save the new format mask.