The grouping separator is typically used for thousands, but in some countries it separates ten-thousands. They must be quoted, unless noted otherwise, if they are to appear in the prefix or suffix as literals.ĭecimal separator or monetary decimal separator Special characters, on the other hand, stand for other characters, strings, or classes of characters. Many characters in a pattern are taken literally they are matched during parsing and output unchanged during formatting. If a $ is used, then the $ will always appear, regardless of currency setting.įormatNumber(., '#,#0.00 (#,#0.00)')įor additional details on formatting numbers, refer to: Note that the & represents the local currency format. "Week Year" is the year of the end of the week containing the specified date (when the calendar supports "week year").įormats a number using the pattern specified.
For example, MM/DD/yyyy applied to 03/18/01 returns "Mar 3, 01". If the number of pattern letters is greater than 2, the year is interpreted literally. For example, "yy" applied to results in "97". If the number of pattern letters is 2, the year is truncated to 2 digits. MMM = first 3 characters of month name (Jun) MM = adds leading digit for single digit months (06)
#MATCH THE PREFIX WITH THE POWER OF TEN IT REPRESENTS. FULL#
See for list of available timezones.Į = first 3 characters of day name (Mon, Tue, Wed, Thu, Fri, Sat, Sun)ĮEEE = full text of day name (Monday, Tuesday, Wednesday, Thursday, Friday, Saturday) Note that the special parameter 'User' applies the timezone specified in the current user's User Preferences. The letters in the following table are reserved for their documented date or time pattern all unused letters are also reserved. Surround text with single quotes ( ' ) to avoid misinterpretation. Unquoted letters from a-z and A-Z represent parts of a date or time string. You specify date and time patterns with format strings. For example, you might use GetRelatedEntityValue on a project to get a resource's internal rate, which is a number, or their capacity start date, which is a date. However, some functions can return multiple data types, depending on the data you are returning - these functions are indicated by (various). For example, the FormatDate function returns a String data type the GetChildEntityDate function returns a Date. Note that the data type returned for each function should match the column header unless otherwise indicated by (data type:). Click on a function to see its description, syntax, and example.
The following functions are available for calculated fields. Entity Reference for all GetChildEntity functions.
0 kommentar(er)
