Thanks Norm! Since only two people will be pulling these Word documents I was able to change the setting in their Remedy client Locale from short to Custom and it works perfectly! Have a great day!
~~~~~~~~~~~~~~ Terri -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Kaiser Norm E CIV USAF 96 CS/SCCE Sent: Monday, March 03, 2008 11:36 AM To: [email protected] Subject: Re: $DATE$ Formt Question Easy way: Change the date format in the Windows client. Since AL's pull date from the client, it gets the date format from the client, too. This has to be set on every machine where the AL will run, though. That's OK if you're just running a daily report or something similar from one or two machines. Slightly harder way: Just do a SET FIELDS and do a DIRECT SQL and call the date in the date format from the underlying DB. Here's how to set the date format and do the query: http://infolab.stanford.edu/~ullman/fcdb/oracle/or-time.html Norm -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Lockwood, Teresa L Sent: Monday, March 03, 2008 10:25 AM To: [email protected] Subject: $DATE$ Formt Question ** In an Active Link I'm using DDE to call the command $DATE$ into a Word document. It's working fine except that I need to change the date format from "3/3/08" to March 3, 2008. Any suggestions as to how I can do this are greatly appreciated. Thanks, Terri ARS 6.3 patch 20 ITSM 5.6 AIX 5.3 SQL Oracle 9.2 __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ ________________________________________________________________________ _______ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
