2022.2

Building Currency values
CurrencyvaluescanbetheresultofdirectattributionormathematicaloperationsjustlikeIntegerval-
ues(see"Integer"onpage281).
Date
Datesarevaluesthatrepresentaspecificpointintime,preciseuptothesecond.Theycanalsobe
referredtoasdatetimevalues.WhiledatesaredisplayedasUTC(CoordinatedUniversalTime)or
usingthesystem'sregionalsettings(see"DefaultFormat"onpage786),inrealitytheyarestored
unformatted.
Note: TheDatepropertyisstoredintheConnectdatabasewithzerotimezoneoffset,which
makesitpossibletoconvertthetimecorrectlyinanylocation.PlanetPressWorkflow,however,
showsthedate/timeasitisstoredinthedatabase(with0timezoneoffset).Thisisexpected
behaviorandthezoneoffsetmustbecalculatedmanuallyinPlanetPressWorkflow.
Extracting dates
ToextractdataandhavethatdatainterpretedasaDate,setthetypeoftherespectivefieldtoDate:
1. Selectthefieldinthedatamodel.
2. OntheStep propertiespane,underField Definition,specifytheTypeasDate.
3. Makesurethatthedateinthedatasourceisformattedinawaythatmatchestheexpectationsof
theDataMapper.Ifthedatedoesn'tmatchtheformatthattheDataMapperexpects,itcannotbe
interpretedasadate.Forexample,ifadateinthedatasourceisformattedas"yyyy-mm-dd"but
theDataMapperexpectsatimeaswell,thedatecannotbereadandtheDataMapperwillstop
withanerror.
Theexpecteddateformatcanbesetinthreeplaces:
l
Intheuserpreferences("DataMapperpreferences"onpage786).
l
Inthedatasourcesettings("Datasourcesettings"onpage223).
l
Inthefieldproperties:ontheStep propertiespane,underData Format,specifythe
Date/Time Format.
4. Forthelettersandpatternsthatyoucanuseinadateformat,see"Definingadate/timeformat"
onthenextpage.
DataformatsettingstelltheDataMapperhowtoreadandparsedatafrom the data source.
Theydon'tdeterminehowthesedataareformattedintheDataModelorinatemplate.Inthe
DataModel,dataareconvertedtothenativedatatype.Dates,forexample,areconvertedtoa
Page 278