2022.2

Examples of masks
Value in raw data Mask to use
June25,2013 MMdd,YYYY
06/25/13 mm/dd/yy
2013.06.25 yyyy.mm.dd
2013-06-2507:31PM yyyy-mm-ddhh:nnap
2013-06-2519:31:14.1206 yyyy-mm-ddhh:nn:ss.ms
Tuesday,June25,2013@7h31PM DD,MMdd,yyyy@hh\hnnap
Entering a date using JavaScript
InseveralplacesintheDataMapper,DatevaluescanbesetthroughaJavaScript.Forexample:
l
InafieldintheDataModel.Todothis,gototheStepspaneandselectanExtractstep.Then,on
theSteppropertiespane,underFieldDefinitionclicktheAdd JavaScript Fieldbutton(nextto
theFieldListdrop-down).TypetheJavaScriptintheExpressionfield.(Torenamethefield,click
theOrderandrenamefieldsbutton.)
l
InaPreprocessor property.Todothis,gototheStepspaneandselectthePreprocessorstep.
Then,ontheSteppropertiespane,underPropertiesaddaproperty,specifyitsTypeasDateand
puttheJavaScriptintheDefaultValuefield.
TheuseoftheJavaScriptDate()objectisnecessarywhencreatingdatesthroughaJavaScriptexpres-
sion.Formoreinformation,seew3schools-JavaScriptDatesandw3schools-DateObject.
Example: Thefollowingscriptcreatesadatethatisthecurrentdate+30days:
function addDays(date, days) {
var result = new Date(date);
result.setDate(result.getDate() + days);
return result;
}
addDays(new Date(), 30);
Page 280