Difference between revisions of "Database Format"
From AgileApps Support Wiki
imported>Aeric |
imported>Aeric |
||
| Line 5: | Line 5: | ||
|- | |- | ||
| '''Date, DateTime, | | '''Date, DateTime, Time''' || [[UTC Format]] | ||
|- | |- | ||
| valign="top" | '''Currency, Number,<br>Number with Decimal, Percent''' | | valign="top" | '''Currency, Number,<br>Number with Decimal,<br>Percent''' | ||
| | | | ||
* No currency symbol or percent sign | * No currency symbol or percent sign | ||
Revision as of 00:48, 23 August 2013
The database format is the format in which data is stored in the database.
Field Format Date, DateTime, Time UTC Format Currency, Number,
Number with Decimal,
Percent- No currency symbol or percent sign
- No grouping characters (e.g. commas) in whole-number portion
- A decimal point (.) before fractional portion
Ex: 84954.32
Lookup - The Record ID of a record in the target object.
Ex: 123A456B78
Multi Object Lookup Ex: 849Z:123A456B78
See also: User Format