2022.2

Example: {{dateLongDueDate}}
Inthisexample,dateLongistheHelper,andDueDateisthenameofadatafieldthatcontainsadate.
Theexpressionreturnsthedate,formattedasalongdate,e.g.February 23, 2022.
Note: Therulesofthecurrentlocalealsoinfluencethewaythedataisformatted;see"Locale"on
page706.
Tochangetheformatoftheoutputofanexpression,simplytypethenameofaHelperintheexpres-
sion.WhichHelpersworkdependsonthetypeofthedata.
ThistopicliststheavailableHelpersthatcanformatavaluebydatatype.
Note: ThenamesoftheseHelpersarecasesensitive.Forexample,"upperCase"works,but
"uppercase"doesnot.
TextHelpers
ThesearetheFormatHelpersthatcanbeusedwithtext.
l
lowerCasetransformsallcharacterstolowercase.
l
upperCasetransformsallcharacterstouppercase.
l
properCasetransformsthefirstcharacterofeachwordtouppercaseandallothercharactersto
lowercase.
NumberHelpers
ThefollowingFormatHelpersworkwithnumbers,i.e.datafieldsofthetypeCurrency,Floatand
Integer.
l
currencyformatsanumberasanamountofmoney,withacurrencysymbol.
Optionally,youcanspecifyacustompattern.Putthepatternafterthenameofthedatafield,and
encloseitindoublequotes.
Example: {{currencyTotal"#.0"}}
Foravailablepatterns,see"Numberpatterns"onpage1196.
l
currencyNoSymbolformatsanumberasacurrencywhilstomittingthecurrencysymbol.
l
groupedformatsanumberusingathousandsseparator.
Note: WhichcurrencysymbolandwhichthousandsseparatorareuseddependsontheLocale;
see"Locale"onpage706.
Page 770