Formatting Report Data
The format strings that are used in Docentric AX designer are the standard format strings in .NET. Here it is the complete list of them:
- Standard numeric format strings
- Custom numeric format strings
- Standard Date and Time Format Strings
- Custom Date and Time Format Strings
In short, to get the standard number of decimals for amounts, n should be used as format string. For EN-US the same result we would get if we used n2. And for 0 decimals (e.g. for quantities), we should use n0.
For short dates we should use d, the standard short date format string, while for standard long dates we should use D. Standard short date and time format string is g, and the standard long date and time format string is G.