Try selecting your date variable so it goes into the WorkStation's data box, View the String Formatter, and either:
set mmddyyy as the "Pattern:" or put a / in "Search:" and select "Delete" and click "Learn This:" Rich McNeil Boston Software Systems 866 653 5105 x 813 www.bostonworkstation.com From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Thom C.Blackwell Sent: Monday, March 05, 2007 2:14 PM To: [email protected] Subject: RE: [Talk] reformating dates Greetings, BWS has a command called STRReplace that you could use: Temp=strreplace(theDate,"/","") Or investigate the Formatter toolbar - which can quickly change the date format - and do other similar type functions. Regards, Thom Thom C. Blackwell Product Manager Boston Software Systems (866) 653-5105 ex 807 www.bossoft.com LEGAL NOTICE Unless expressly stated otherwise, this message is confidential and may be privileged. It is intended for the addressee(s) only. Access to this E-mail by anyone else is unauthorized. If you are not an addressee, any disclosure or copying of the contents of this E-mail or any action taken (or not taken) in reliance on it is unauthorized and may be unlawful. If you are not an addressee, please inform the sender immediately, then delete this message and empty from your trash. From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Sebastian,Denise Sent: Monday, March 05, 2007 2:07 PM To: [email protected] Subject: RE: [Talk] reformating dates Gary, Use two things and array and split. array = split(string , "/") string = array(0)+array(1)+array(2) This is how I have done it in the past. Denise Sebastian _____ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Gary Williams Sent: Monday, March 05, 2007 11:06 AM To: [email protected] Subject: [Talk] reformating dates I am working on a new script and my input file from pharmacy has the date as 07/14/2004. The meditech fieldwants it in a format of 07042004. Can the script remove the "/"? Thanks Gary Williams Data Tech Memorial Hospital
