Steve, One word of caution with this method. Your xxxx index part of the new number will not reset on the next day. It may not even roll-over past 9999 properly. I never pushed the RequestID that far.
I did a version of this for a material request form. First and Last Intials+Year+Month+Day+xx index. I had to basically build my own Next_ID form for each Material handler and reset it every night at 12:00:00 AM so each day's first request was like JR2007042201. I don't like data encoded into an id because someone will always ask you to extend it for yet another parameter. I try to tell them, "Use the database search functions to retrieve what you need. That's why we built it." HTH, John J. Reiser Software Development Analyst Remedy Administrator/Developer Lockheed Martin - MS2 The star that burns twice as bright burns half as long. Pay close attention and be illuminated by its brilliance. - paraphrased by me -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Steven Pataray Sent: Monday, April 23, 2007 3:08 PM To: [email protected] Subject: Re: Date in Case number ** Fred, That seemed to work very well, all in one filter. Here's my computed value incase someone can use it. ((( "HD" + DATENUM( "yyyy", $DATE$)) + LPAD(DATENUM( "mm", $DATE$), 2, "00")) + LPAD(DATENUM( "dd", $DATE$), 2, "00")) + LPAD($Request ID$, 4, "0000") My result was: HD200704230010 Thanks Steve On 4/23/07, Grooms, Frederick W <[EMAIL PROTECTED]> wrote: ** Actually I would use a filter to push the value to the new field. Since a Push action occurs in Phase 2 the Entry ID is available for use. Simply do a filter that pushes the the same record your new field data Push Fields If: $Entry ID$ = 'Entry ID' Field: YourNewField Value: Your computed value Fred ________________________________ From: Action Request System discussion list(ARSList) [mailto: _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
