Convert Date Autoentry

%3CLINGO-SUB%20id%3D%22lingo-sub-1447167%22%20slang%3D%22en-US%22%3EConvert%20Date%20Autoentry%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1447167%22%20slang%3D%22en-US%22%3E%3CP%3EI%20use%20client%20management%20software%20to%20track%20various%20dates%20for%20legal%20deadlines.%26nbsp%3B%20My%20CMS%20will%20populate%20Microsoft%20Word%20documents%20I%20have%20prepared%20and%20stored%20in%20my%20CMS.%26nbsp%3B%20The%20dates%20iare%20stored%20in%20the%20following%20format%3A%20%22mm%2Fdd%2Fyyyy%22.%26nbsp%3B%20When%20the%20Word%20templates%20I%20prepared%20are%20auto-populated%20with%20the%20date%20from%20CMS%20it%20is%20in%20the%20same%20format%20as%20previously%20stated%2C%20but%20that's%20not%20how%20it%20needs%20to%20be%20presented%20on%20legal%20pleadings%2C%20correspondence%2C%20etc.%3CBR%20%2F%3E%3CBR%20%2F%3EI%20cannot%20change%20how%20the%20CMS%20stores%20the%20dates%20because%20they%20are%20used%20to%20calculate%20statutory%20deadlines.%26nbsp%3B%20Is%20there%20an%20macro%20or%20other%20setting%20I%20can%20set%20in%20my%20template%20that%20will%20automatically%20convert%20the%20date%20from%20%22mm%2Fdd%2Fyyyy%22%20to%20a%20date%20that%20looks%20like%2C%20%22March%2018%2C%202020%22%20when%20the%20document%20is%20generated%3F%26nbsp%3B%26nbsp%3B%3CBR%20%2F%3E%3CBR%20%2F%3EJust%20to%20give%20you%20an%20idea%20how%20the%20Word%20templates%20are%20formatted%2C%20if%20I'm%20working%20with%20%22Signing%20Date%22%20in%20CMS%2C%20then%20the%20Word%20document%20will%20have%20a%20merge%20field%20that%20reads%20%23Matter.Signing%20Date%23.%26nbsp%3B%20To%20capitalize%20other%20merge%20fields%20I%20can%20highlight%20the%20entire%20merge%20field%2C%20open%20%22Font%22%20and%20select%20%22All%20Caps%22%2C%20and%20that%20will%20preserve%20the%20format%20for%20the%20merge%20field%20and%20give%20me%20all%20caps%20(I%20cannot%20just%20type%20the%20merge%20field%20in%20all%20caps).%26nbsp%3B%26nbsp%3B%3CBR%20%2F%3E%3CBR%20%2F%3EI%20appreciate%20in%20advance%20your%20assistance.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

I use client management software to track various dates for legal deadlines.  My CMS will populate Microsoft Word documents I have prepared and stored in my CMS.  The dates iare stored in the following format: "mm/dd/yyyy".  When the Word templates I prepared are auto-populated with the date from CMS it is in the same format as previously stated, but that's not how it needs to be presented on legal pleadings, correspondence, etc.

I cannot change how the CMS stores the dates because they are used to calculate statutory deadlines.  Is there an macro or other setting I can set in my template that will automatically convert the date from "mm/dd/yyyy" to a date that looks like, "March 18, 2020" when the document is generated?  

Just to give you an idea how the Word templates are formatted, if I'm working with "Signing Date" in CMS, then the Word document will have a merge field that reads #Matter.Signing Date#.  To capitalize other merge fields I can highlight the entire merge field, open "Font" and select "All Caps", and that will preserve the format for the merge field and give me all caps (I cannot just type the merge field in all caps).  

I appreciate in advance your assistance.

0 Replies