2022.2

putinthefollowingorder:year,month,day,andoptionallyhours,minutes,seconds,milliseconds(see
https://www.w3schools.com/js/js_dates.aspandhttps://developer.mozilla.org/en-US/-
docs/Web/JavaScript/Reference/Global_Objects/Date.)Whenthetimeisomitted,itdefaultsto
12:00:00AM.
/* Convert the string 21-12-1997 into a valid JavaScript date */
var strDate = record.fields["date"];
var dateParts = strDate.split("-");
var date = new Date(dateParts[2], (dateParts[1] - 1), dateParts[0]);
Note: JavaScriptcountsmonthsfrom0to11.Januaryis0.Decemberis11.
AnotherwaytoputastringinaDateistousetheDate.parsefunction;seehttps://developer-
.mozilla.org/en-US/docs/Web/JavaScript/Reference/Global_Objects/Date/parse.
Thedatevariablecanbeusedasthevalueinthedate,dateTimeortimefunctionsoftheformatter.
var myDate = formatter.date(date, "MM/dd/yyyy");
Thecustompatternthatthescriptprovides,outputsthemonthanddayintwodigitseachandtheyear
infourdigits:05/21/2016.Formoreexamplesofformattingpatterns,see"Dateandtimepatterns"
below.
Date and time patterns
Datesandtimesinatemplateoriginatingfromadatefieldinarecordsetcanbedisplayedusingacus-
tompattern.YoucanenterthepatternviatheHelperWizardortheTextScriptWizard,lestthefield
typeissettoDateinadatamappingconfigurationandthefieldcontainsavaliddate;see"Usingthe
HelperWizard"onpage725,"UsingtheTextScriptWizard"onpage729and"Formattingvariable
data"onpage732.IntheScriptEditor,thepatterncanbepassedtoadate,dateTimeorTimefunction
oftheformatter;see"formatter"onpage1175.
Thecustompatternmayconsistofpatternletters(seebelow),forexample:"MM/dd/yyyy".Thecom-
ponentscanbeseparatedwithaspaceorasymbol,e.g..,/,-.Textmustbeputinquotes.
Therepetitionofpatternlettersdeterminestheexactpresentation.Forexample,ifthenumberofpat-
ternlettersforamonthislessthan3(MorMM),themonthisdisplayedasanumber.Ifthenumberof
patternlettersis3(MMM),itwillbedisplayedastext;ifavailable,ashortorabbreviatedformofthe
month'snamewillbeused.Ifthenumberofpatternlettersis4ormore(MMMM),themonth'sfullname
isdisplayed.
Note: Thepatternlettersandpatternsonthispageareonlysuitablefordisplayingdatesand
timesintemplates,notforextractingdatesintheDataMappermodule.Forpatternlettersandpat-
ternsavailableintheDataMapper,see"Date"onpage278.
Page 1180