Unformatted Attribute Values
Unformatted attribute values are used:
- For any date, date and time or time of day values used when writing rules in Word or Excel (for example, constants, values used in comparisons), in default values on screen controls, and in maximum and minimum allowed values for non-Boolean attributes.
- For any currency, date, date and time or time of day attributes in the Debugger on the Data tab in the Value column.
- In document templates using Analytics Publisher, to control the display of images and text.
- For number attributes flagged in the Edit Attribute dialog as Unformatted, where formatted values would normally be used when displaying the values of the attribute.
Unformatted values take the forms specified in the table below.
| Attribute type | Unformatted value form | Example |
|---|---|---|
|
Boolean |
true false |
true |
|
Number |
x (no grouping separator, zero or more decimal places) |
3 1234.56 |
|
Number (unformatted) |
x (no grouping separator, zero or more decimal places) |
3 1234.56 |
|
Currency |
x (no currency symbol, no comma, zero or more decimal places) |
50000 |
|
Text |
any text (with the text surrounded by quotation marks where referenced in rules) |
yellow |
|
Date |
YYYY-MM-DD |
2007-10-25 |
|
Time of day |
hh:mm:ss |
07:47:31 |
|
Date and time |
YYYY-MM-DD hh:mm:ss z |
2009-08-12 17:30:00 EDT |
Where the formatting of dates and times are referred to the following conventions are used:
- yyyy refers to a four-digit year
- MM refers to a two-digit month (01 through 12)
- dd refers to a two-digit day of month (0 through 31)
- HH refers to two-digits of hour (00 through 23)
- mm refers to two-digits of minute (00 through 59)
- ss refers to two-digits of seconds (00 through 59)
- z refers to the time zone code (up to four characters) or GMT offset (GMT + 00:00 through 12:00 or GMT - 00:00 through 14:00). Time zone is only relevant for datetime attributes and is set separately from the project region. For more information, see Change the Time Zone for a Project.