John you are correct that is what I was seeing when I tried to set this to 11:59PM it would push the due date to 8:00AM the start of Business time for the day. This brings the next problem if the ticket is pushed to 5:00:00PM and it's put into pending for just a moment it will be pushed to 8:00:00AM the next day. So it's possible that someone could drag out a ticket for weeks.
I just see to many ways for someone to trick the system, but this is what they want to be done. Dan Caissie -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Reiser, John J Sent: Tuesday, May 01, 2007 8:27 AM To: [email protected] Subject: Re: timestamp question (set date and time) Fred, That looks good but you would have to use a REPLACE() to change the 12:00:00 AM to 5:00:00 PM and just leave off the +"5:00:00 PM". Dan, Try experimenting with the Business Time form and Process commands. If you set a record in Business Time Workdays to a Start time of 5:00:00 PM and a Stop time of 5:00:01 PM then do some creative adding of time, you can return a time of 5:00:00 PM every time. And I think it will account for DST conversions. When the time you add falls short of the Business Time start (5:00:00 PM) it will 'bump' it up to that time. Try adding 1 second to your time and it should take any time before 5 PM and bump it up to 5 PM. Any time after 5 PM will be bumped to 5 PM of the next day listed in your Business Time Workdays record. So if you were to skip Sat & Sun all times created after 5PM Fri would be set in the new field as 5 PM Monday. Hope that makes some sense. 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 Grooms, Frederick W Sent: Monday, April 30, 2007 5:26 PM To: [email protected] Subject: Re: timestamp question (set date and time) ** You can always set a Character field to $DATE$ + " 5:00:00 PM" and then move that to your Date/Time field Fred ________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Eric Cleereman (IT) Sent: Monday, April 30, 2007 12:56 PM To: [email protected] Subject: Re: timestamp question (set date and time) ** This should logic should work, unless the date happens to fall on the first day of Daylight Saving Time or of Standard Time, at which point the time set would end up being 6:00 PM or 4:00 PM. Aside from a lookup table, does anyone have any ideas how to prevent this logic from running into problems on those dates? Eric Cleereman -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Wacholz, Jeanette (Jenni) Sent: Monday, April 30, 2007 1:29 PM To: [email protected] Subject: Re: timestamp question (set date and time) ** $DATE$ + (60*(60*17)) should always give you 5pm of the current date as long as the escalation runs between midnight and 5pm. Jenni Wacholz Remedy Administration Coventry Health Care Inc 480-445-2517 ________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Dan Caissie Sent: Monday, April 30, 2007 6:47 AM To: [email protected] Subject: timestamp question (set date and time) ** Good Monday morning everyone :-) I have an escalation that runs at 1AM and what I want it to do is set a field to 5 PM for the current day. 4/DATE/2007 5:00:00 PM right now I was doing $TIMESTAMP$ + (60 * (60 * 16)) but if the escalation is delayed at all it will push the timestamp past 5 PM. So is there better way of doing this I bet there is any help would be great. 6.3 Windows SQL Dan Caissie __20060125_______________________This posting was submitted with HTML in it___ ________________________________________________________________________ _______ 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"
