Thanks Fred, that did the trick. I completely forgot about the LPAD command. Must be getting old.
Christopher Pruitt EDS, an HP Company mailto: [EMAIL PROTECTED] We deliver on our commitments so you can deliver on yours. Confidentiality Notice: This message and any files transmitted with it are intended for the sole use of the entity or individual to whom it is addressed, and may contain information that is confidential, privileged, and exempt from disclosure under applicable law. If you are not the intended addressee for this e-mail, you are hereby notified that any copying, distribution, or dissemination of this e-mail is strictly prohibited. If you have received this e-mail in error, please immediately destroy, erase, or discard this message. Please notify the sender immediately by return e-mail if you have received this e-mail by mistake. ________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Grooms, Frederick W Sent: Monday, October 27, 2008 4:42 PM To: arslist@ARSLIST.ORG Subject: Re: Active Link Function in an Escalation??? ** What kind of error are you getting using TIMESTAMP? I have used the DAY, MONTH, and YEAR functions in set fields before with no problems (Except having to use LPAD as well). "Escalation_" + LPAD(YEAR($TIMESTAMP$),4,"2000") + LPAD(MONTH($TIMESTAMP$),2,"00") + LPAD(DAY($TIMESTAMP$),2,"00") + ".log" Fred ________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Pruitt, Christopher J Sent: Monday, October 27, 2008 4:00 PM To: arslist@ARSLIST.ORG Subject: Re: Active Link Function in an Escalation??? ** Yes, but it still does not get us to the YYYYMMDD format we need. We can get DDMMYY at best so far. Christopher Pruitt EDS, an HP Company mailto: [EMAIL PROTECTED] We deliver on our commitments so you can deliver on yours. Confidentiality Notice: This message and any files transmitted with it are intended for the sole use of the entity or individual to whom it is addressed, and may contain information that is confidential, privileged, and exempt from disclosure under applicable law. If you are not the intended addressee for this e-mail, you are hereby notified that any copying, distribution, or dissemination of this e-mail is strictly prohibited. If you have received this e-mail in error, please immediately destroy, erase, or discard this message. Please notify the sender immediately by return e-mail if you have received this e-mail by mistake. ________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Joe DeSouza Sent: Monday, October 27, 2008 3:49 PM To: arslist@ARSLIST.ORG Subject: Re: Active Link Function in an Escalation??? ** Chris, Have you tried replacing the invalid characters to either null or an underscore or something? Joe ----- Original Message ---- From: "Pruitt, Christopher J" <[EMAIL PROTECTED]> To: arslist@ARSLIST.ORG Sent: Monday, October 27, 2008 2:13:37 PM Subject: Active Link Function in an Escalation??? Hello Fellow Listers, Does anyone know a way to mimic the Active Link functions within an Escalation? I am trying to find a way to do the following to create log entries, on a UNIX server, that have a unique timestamp. These logs turn on and off every day. These logs are created via a SET FIELDS action into the field 'escalationlogfile' on the "AR System Administration: Server Information" form. We are able to turn the log on and off at defined times. Currently we are using "Escalation_" + REPLACE(DATE($DATE$), "/", "")) + ".log" and it crates a log file with the name "Escalation_102708.log" However, we would like to name the file Escalation_20081027.log so that it is in the format YYYYMMDD. We have tried this command but it does not work. "Escalation_" + YEAR($TIMESTAMP$)) + MONTH($TIMESTAMP$)) + DAY($TIMESTAMP$) + ".log" I can't use $TIMESTAMP$ and that is not a valid UNIX file name, meaning the file name comes across as Escalation_10/27/288 12:00:00 PM.log, which is not valid. Any help would be appreciated. Christopher Pruitt EDS, an HP Company mailto: [EMAIL PROTECTED] We deliver on our commitments so you can deliver on yours. Confidentiality Notice: This message and any files transmitted with it are intended for the sole use of the entity or individual to whom it is addressed, and may contain information that is confidential, privileged, and exempt from disclosure under applicable law. If you are not the intended addressee for this e-mail, you are hereby notified that any copying, distribution, or dissemination of this e-mail is strictly prohibited. If you have received this e-mail in error, please immediately destroy, erase, or discard this message. Please notify the sender immediately by return e-mail if you have received this e-mail by mistake. __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"