I'm not going to suggest to reset the index to 0000 at midnight. If I'm forced into doing this I would rather the index and the old Case ID be the same number so it can be searched by either method. I'm going to increase the 0000 to something more like 000000 then possibly provide that in reports like what Rick suggested.
Thanks for your input. Steve On 4/23/07, Reiser, John J <[EMAIL PROTECTED]> wrote:
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: arslist@ARSLIST.ORG 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"
_______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"