Okay! Thanks for the advise. I'll try it then i'll give you feedback. Thanks Joe & Frank!
Frank Caruso-2 wrote: > > The return value from the calculation is the difference in seconds. You > cannot set a datetime field to that value. > > You want to report the duration of the alarm which cannot be reported in a > date format. It can be reported as the number of minutes or hours or days > or > as a combination such as 3:10 (3 hours 10 minutes). > > Sore the Alarm Duration as an integer and then convert it to minutes, > days, > hours, etc.... > On Mon, Jul 13, 2009 at 10:37 AM, kryptonboy22 > <[email protected]>wrote: > >> Frank here's the formula you gave, and changes some part of it: >> $PROCESS$ @@:Application-Bus-Time-Diff $Alarm End Date$ $Alarm Start >> Date$ >> >> and the image is like this: >> ALARM START DATE : 7/1/2009 12:00:00 AM >> ALARM END DATE : 7/30/2009 12:00:00 AM >> ALARM DURATION : 1/1/1970 8:00:00 AM >> >> >> Well you see the output (ALARM DURATION ) is not correct if you're going >> to >> subtract the start and the end date. >> >> Gee! thanks for the help >> >> >> >> Frank Caruso-2 wrote: >> > >> > Sorry. I cannot view the image in the URL provided. >> > >> > On Mon, Jul 13, 2009 at 10:03 AM, kryptonboy22 >> > <[email protected]>wrote: >> > >> >> Yah! But how can i show the output like the one in the image? >> >> I tried the one you gave me but i have to change a bit cause im >> getting >> >> an >> >> error >> >> >> >> I tried this one but yet the output didn't change. >> >> $PROCESS$ @@:Application-Bus-Time2-Diff "Alarm Start Date" "Alarm End >> >> Date" >> >> >> >> Heres the output: >> >> http://www.nabble.com/file/p24457053/rx2.jpg >> >> >> >> Anyway Frank big thanks! >> >> >> >> >> >> >> >> Frank Caruso-2 wrote: >> >> > >> >> > There are numerous ways to calculate the difference between two >> >> datetime >> >> > fields as well as numerous formats for the output. I would suggest >> you >> >> > read >> >> > the PDF on Workflow Objects, specifically the section that deals >> with >> >> > Business Time calculations. There are several commands that can >> >> calculate >> >> > the difference between two datetime values. >> >> > >> >> > In short, what you want to do is run the following in a set fields >> >> action >> >> > on >> >> > gain focus: >> >> > >> >> > $PROCESS$ @@:Application-Bus-Time2-Diff "Alarm Start Date" "Alarm >> End >> >> > Date" >> >> > >> >> > This will return the difference in seconds. >> >> > >> >> > >> >> > >> >> > On Mon, Jul 13, 2009 at 9:11 AM, kryptonboy22 >> >> > <[email protected]>wrote: >> >> > >> >> >> The users want a new field which can compute the given formula when >> >> >> (Alarm >> >> >> End Date ) field was supplied by a date. >> >> >> >> >> >> Formula: (Alarm End Date - Alarm Start Date) * 24 >> >> >> >> >> >> So i created a new field named Alarm duration, which can show the >> >> output >> >> >> for >> >> >> the said formula. >> >> >> I used Active link upon lost focus of (Alarm End Date) field and >> when >> >> >> date >> >> >> is supplied. >> >> >> >> >> >> See image >> >> >> http://www.nabble.com/file/p24456669/rx.jpg >> >> >> >> >> >> Thanks for the help. Im not good at this! >> >> >> >> >> >> >> >> >> Frank Caruso-2 wrote: >> >> >> > >> >> >> > Please explain exactly what you are trying accomplish so the >> >> >> appropriate >> >> >> > solution can be provided. >> >> >> > >> >> >> > >> >> >> > On Mon, Jul 13, 2009 at 8:59 AM, kryptonboy22 >> >> >> > <[email protected]>wrote: >> >> >> > >> >> >> >> The user wants to multiply it to 24 hrs. But still have a >> problem >> >> in >> >> >> date >> >> >> >> subtraction. >> >> >> >> (Alarm End Date - Alarm Start Date ) well this one still not >> giving >> >> >> the >> >> >> >> right output even without multiplying it to 24 >> >> >> >> >> >> >> >> http://www.nabble.com/file/p24456541/rx.jpg >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> Frank Caruso-2 wrote: >> >> >> >> > >> >> >> >> > If you are trying to Run something when the difference is >> greater >> >> >> than >> >> >> >> 24 >> >> >> >> > hours try this: >> >> >> >> > >> >> >> >> > (Alarm End Date - Alarm Start Date) >= (60*60*24) >> >> >> >> > >> >> >> >> > This will Run if End Date - Start date is greater than 24 >> hours >> >> (1 >> >> >> >> day). >> >> >> >> > >> >> >> >> > 60 seconds * 60 minutes * 24 hours = total number of seconds >> in >> >> 1 >> >> >> day >> >> >> >> > (86400). >> >> >> >> > >> >> >> >> > All datetime fields are stored as the number of seconds since >> >> >> 1/1/1970. >> >> >> >> > On Mon, Jul 13, 2009 at 8:35 AM, kryptonboy22 >> >> >> >> > <[email protected]>wrote: >> >> >> >> > >> >> >> >> >> Im a newbie in Remedy. Im having a hard time with Date/Time >> >> >> formula. >> >> >> >> Can >> >> >> >> >> any >> >> >> >> >> one help me with this formula. Cant get the right output >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> (Alarm End Date - Alarm Start Date) * 24 hours >> >> >> >> >> >> >> >> >> >> Thanks alot guys! >> >> >> >> >> -- >> >> >> >> >> View this message in context: >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> http://www.nabble.com/BMC-Remedy%3A-Subtract-Date-Time-tp24455900p24455900.html >> >> >> >> >> Sent from the ARS (Action Request System) mailing list >> archive >> >> at >> >> >> >> >> Nabble.com. >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> _______________________________________________________________________________ >> >> >> >> >> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org >> >> >> >> >> Platinum >> >> >> >> >> >> >> >> >> Sponsor:[email protected]<sponsor%[email protected]>< >> sponsor%[email protected] <sponsor%[email protected]> >> >< >> >> >> sponsor%[email protected]<sponsor%[email protected]>< >> sponsor%[email protected]<sponsor%[email protected]> >> > >> >> >< >> >> >> >> >> >> sponsor%[email protected]<sponsor%[email protected]> >> <sponsor%[email protected]<sponsor%[email protected]> >> >< >> >> >> sponsor%[email protected]<sponsor%[email protected]> >> <sponsor%[email protected]<sponsor%[email protected]> >> > >> >> > >> >> >> >< >> >> >> >> >> >> >> >> >> >> sponsor%[email protected]<sponsor%[email protected]> >> <sponsor%[email protected]<sponsor%[email protected]> >> > >> >> >> <sponsor%[email protected]<sponsor%[email protected]> >> <sponsor%[email protected]<sponsor%[email protected]> >> > >> >> >< >> >> >> >> >> >> sponsor%[email protected]<sponsor%[email protected]> >> <sponsor%[email protected]<sponsor%[email protected]> >> > >> >> >> <sponsor%[email protected]<sponsor%[email protected]> >> <sponsor%[email protected]<sponsor%[email protected]> >> > >> >> > >> >> >> > >> >> >> >> >ARSlist: >> >> >> >> >> "Where the Answers Are" >> >> >> >> >> >> >> >> >> > >> >> >> >> > >> >> >> >> >> >> >> >> >> >> _______________________________________________________________________________ >> >> >> >> > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org >> >> >> >> > Platinum >> >> >> >> >> >> Sponsor:[email protected] <sponsor%[email protected]>< >> sponsor%[email protected] <sponsor%[email protected]> >> >< >> >> >> sponsor%[email protected]<sponsor%[email protected]>< >> sponsor%[email protected]<sponsor%[email protected]> >> > >> >> >< >> >> >> >> >> >> sponsor%[email protected]<sponsor%[email protected]> >> <sponsor%[email protected]<sponsor%[email protected]> >> >< >> >> >> sponsor%[email protected]<sponsor%[email protected]> >> <sponsor%[email protected]<sponsor%[email protected]> >> > >> >> > >> >> >> >ARSlist: >> >> >> >> "Where the Answers Are" >> >> >> >> > >> >> >> >> > >> >> >> >> >> >> >> >> -- >> >> >> >> View this message in context: >> >> >> >> >> >> >> >> >> >> http://www.nabble.com/BMC-Remedy%3A-Subtract-Date-Time-tp24455900p24456541.html >> >> >> >> Sent from the ARS (Action Request System) mailing list archive >> at >> >> >> >> Nabble.com. >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> _______________________________________________________________________________ >> >> >> >> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org >> >> >> >> Platinum >> >> >> >> >> >> Sponsor:[email protected] <sponsor%[email protected]>< >> sponsor%[email protected] <sponsor%[email protected]> >> >< >> >> >> sponsor%[email protected]<sponsor%[email protected]>< >> sponsor%[email protected]<sponsor%[email protected]> >> > >> >> >< >> >> >> >> >> >> sponsor%[email protected]<sponsor%[email protected]> >> <sponsor%[email protected]<sponsor%[email protected]> >> >< >> >> >> sponsor%[email protected]<sponsor%[email protected]> >> <sponsor%[email protected]<sponsor%[email protected]> >> > >> >> > >> >> >> >ARSlist: >> >> >> >> "Where the Answers Are" >> >> >> >> >> >> >> > >> >> >> > >> >> >> >> >> >> _______________________________________________________________________________ >> >> >> > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org >> >> >> > Platinum >> >> >> >> Sponsor:[email protected]<sponsor%[email protected]>< >> sponsor%[email protected] <sponsor%[email protected]> >> >< >> >> >> sponsor%[email protected]<sponsor%[email protected]>< >> sponsor%[email protected]<sponsor%[email protected]> >> > >> >> >ARSlist: >> >> >> "Where the Answers Are" >> >> >> > >> >> >> > >> >> >> >> >> >> -- >> >> >> View this message in context: >> >> >> >> >> >> http://www.nabble.com/BMC-Remedy%3A-Subtract-Date-Time-tp24455900p24456669.html >> >> >> Sent from the ARS (Action Request System) mailing list archive at >> >> >> Nabble.com. >> >> >> >> >> >> >> >> >> >> >> >> _______________________________________________________________________________ >> >> >> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org >> >> >> Platinum >> >> >> >> Sponsor:[email protected]<sponsor%[email protected]>< >> sponsor%[email protected] <sponsor%[email protected]> >> >< >> >> >> sponsor%[email protected]<sponsor%[email protected]>< >> sponsor%[email protected]<sponsor%[email protected]> >> > >> >> >ARSlist: >> >> >> "Where the Answers Are" >> >> >> >> >> > >> >> > >> >> >> _______________________________________________________________________________ >> >> > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org >> >> > Platinum >> >> Sponsor:[email protected] <sponsor%[email protected]>< >> sponsor%[email protected] <sponsor%[email protected]> >> >ARSlist: >> >> "Where the Answers Are" >> >> > >> >> > >> >> >> >> -- >> >> View this message in context: >> >> >> http://www.nabble.com/BMC-Remedy%3A-Subtract-Date-Time-tp24455900p24457053.html >> >> Sent from the ARS (Action Request System) mailing list archive at >> >> Nabble.com. >> >> >> >> >> >> >> _______________________________________________________________________________ >> >> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org >> >> Platinum >> >> Sponsor:[email protected] <sponsor%[email protected]>< >> sponsor%[email protected] <sponsor%[email protected]> >> >ARSlist: >> >> "Where the Answers Are" >> >> >> > >> > >> _______________________________________________________________________________ >> > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org >> > Platinum >> Sponsor:[email protected]<sponsor%[email protected]>ARSlist: >> "Where the Answers Are" >> > >> > >> >> -- >> View this message in context: >> http://www.nabble.com/BMC-Remedy%3A-Subtract-Date-Time-tp24455900p24457330.html >> Sent from the ARS (Action Request System) mailing list archive at >> Nabble.com. >> >> >> _______________________________________________________________________________ >> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org >> Platinum >> Sponsor:[email protected]<sponsor%[email protected]>ARSlist: >> "Where the Answers Are" >> > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are" > > -- View this message in context: http://www.nabble.com/BMC-Remedy%3A-Subtract-Date-Time-tp24455900p24457658.html Sent from the ARS (Action Request System) mailing list archive at Nabble.com. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are"
