2022.2

Table Of Contents
fileordatabasewithoutadatamappingconfiguration,allfieldsaretextfields(fieldsofthetype
string).
Whenthesoftwarewarnsaboutamismatchbetweenthetypeofafieldinthewizardandinthecurrent
datamodel,clicktheRefreshTypesbuttontoupdatefieldtypesinthewizardtomatchthetypesinthe
datamodel.
Formattingcanbeappliedtovalues in a Dynamic Tableviathedata-formatattribute.See:"For-
mattingvaluesinaDynamicTable"onpage752.
Youcouldalsoformatdatainascriptusingtheformatter;see"StandardScriptAPI"onpage1169.
Date
Datesinvariabledatacanbedisplayedaslong,mediumandshortdateswithdifferenttimedisplays.
Therearequiteafewpresets,butyoucanalsoenteracustomformatmask.
l
Custom Patternopensadialoginwhichyoucanenteracustompatternthedate(and,option-
ally,thetime).Thedialogshowsanexampleofadateformattedaccordingtothegivenpattern.
Donotputthepatterninquotes.Forpossiblepatternssee"Dateandtimepatterns"on
page1180.
Note: TheCustomPatternoptionisonlyavailablewhenthetypeofthefieldhasbeenset
toDateinthedatamappingconfigurationandthefieldcontainsavaliddate.
l
Default DatedisplaysthedatewiththedefaultpatternforthecurrentLocale.
l
Short Datedisplaystheday,monthandyearintwodigitseach,forexample01.04.16.
l
Medium Datedisplaysthedayandmonthintwodigitseachandtheyearinfourdigits,for
example01.04.2016.(ThisisalsothevalueoftheDefaultDate.)
l
Long Datedisplaysthedayasanumber,themonth'sfullnameandtheyearinfourdigits,for
example1. April 2016.
l
Short Timedisplaysatimeinhoursandminutesintwodigitseach,forexample00:00.
l
Medium Timedisplaysatimeinhours,minutesandsecondsintwodigitseach,forexample
00:00:00.(ThisisalsothevalueoftheDefaultTime.)
l
Long Timedisplaysatimeinhours,minutesandsecondsintwodigitseach,andaddsatime
zone,forexample00:00:00 EDT.
l
Short Date/Timedisplaysthedateasashortdateandthetimeasashorttime,forexample
01.04.16 00:00.
l
Medium Date/Timedisplaysthedateasamediumdateandthetimeasamediumtime,for
example01.04.2016 00:00:00(ThisisalsothevalueoftheDefaultDate/Time.)
Page 733