UI Data Display Formats
When displaying data in the LemonEdge application there is always the option to format that display according to your requirements. By default we support industry standard formatting options to ensure a consistent approach. This guide lists the references and options for detail on how to format the data.
Numbers
All numbers can be formatted using industry standard .net number formatting codes. For example:
- n2: Format the number according to your current culture using 2 decimal places. i.e. for UK English the number 12345.678 would be formatted as 12, 345.67.
- p4: Format the number according to your current culture as a percentage with 4 decimal places. i.e. for UK English the number .3456789 would be formatted as 34.5678%
- c0: Format the number according to your current culture as a currency with 0 decimal places. i.e. for UK English the number 1234.56 would be formatted as £1, 234.
See here for a complete guide on formatting options.
Dates, Times and DateTimes
Dates are formatted using the following international options:
- Long:
International current culture long date format + International current culture long time format - LongDateOnly:
International current culture long date format - LongTimeOnly:
International current culture long time format - Short:
International current culture short date format + International current culture short time format - ShortDateOnly:
International current culture short date format - ShortTimeOnly:
International current culture short time format
Note: If your field holds a date only then selecting an option with time will just show 00:00:00. Vice versa using a format for date with a field that only holds a time will not show relevant date data.