Skip to main content
Planview Customer Success Center

What are the formats for defining export data types?

For number formats, you use a number sign (#) for each digit, and a zero after the decimal point for each decimal place. 

For date formats, use dd, m (or mm, mmm), yy (or yyyy) and a separator to build a format string.

Example:

The values for these data types would be displayed as follows:

  • daNumberType – 12345
  • commaNum – 12345.00
  • daDateType – 02/14/18
  • anothertype – Feb-14-2018

Tip: When you select an export data type as you are creating an export definition, the Format definition list displays a preview. For example, the following screen shot displays the two date types.