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 <kryptonbo...@yahoo.com>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 > > <kryptonbo...@yahoo.com>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 > >> > <kryptonbo...@yahoo.com>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 > >> >> > <kryptonbo...@yahoo.com>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 > >> >> >> > <kryptonbo...@yahoo.com>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:rmisoluti...@verizon.net<sponsor%3armisoluti...@verizon.net>< > sponsor%3armisoluti...@verizon.net <sponsor%253armisoluti...@verizon.net> > >< > >> sponsor%3armisoluti...@verizon.net<sponsor%253armisoluti...@verizon.net>< > sponsor%253armisoluti...@verizon.net<sponsor%25253armisoluti...@verizon.net> > > > >> >< > >> >> > >> sponsor%3armisoluti...@verizon.net<sponsor%253armisoluti...@verizon.net> > <sponsor%253armisoluti...@verizon.net<sponsor%25253armisoluti...@verizon.net> > >< > >> sponsor%253armisoluti...@verizon.net<sponsor%25253armisoluti...@verizon.net> > <sponsor%25253armisoluti...@verizon.net<sponsor%2525253armisoluti...@verizon.net> > > > >> > > >> >> >< > >> >> >> > >> >> > >> sponsor%3armisoluti...@verizon.net<sponsor%253armisoluti...@verizon.net> > <sponsor%253armisoluti...@verizon.net<sponsor%25253armisoluti...@verizon.net> > > > >> <sponsor%253armisoluti...@verizon.net<sponsor%25253armisoluti...@verizon.net> > <sponsor%25253armisoluti...@verizon.net<sponsor%2525253armisoluti...@verizon.net> > > > >> >< > >> >> > >> sponsor%253armisoluti...@verizon.net<sponsor%25253armisoluti...@verizon.net> > <sponsor%25253armisoluti...@verizon.net<sponsor%2525253armisoluti...@verizon.net> > > > >> <sponsor%25253armisoluti...@verizon.net<sponsor%2525253armisoluti...@verizon.net> > <sponsor%2525253armisoluti...@verizon.net<sponsor%252525253armisoluti...@verizon.net> > > > >> > > >> >> > > >> >> >> >ARSlist: > >> >> >> >> "Where the Answers Are" > >> >> >> >> > >> >> >> > > >> >> >> > > >> >> >> > >> >> > >> > _______________________________________________________________________________ > >> >> >> > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > >> >> >> > Platinum > >> >> >> > >> Sponsor:rmisoluti...@verizon.net <sponsor%3armisoluti...@verizon.net>< > sponsor%3armisoluti...@verizon.net <sponsor%253armisoluti...@verizon.net> > >< > >> sponsor%3armisoluti...@verizon.net<sponsor%253armisoluti...@verizon.net>< > sponsor%253armisoluti...@verizon.net<sponsor%25253armisoluti...@verizon.net> > > > >> >< > >> >> > >> sponsor%3armisoluti...@verizon.net<sponsor%253armisoluti...@verizon.net> > <sponsor%253armisoluti...@verizon.net<sponsor%25253armisoluti...@verizon.net> > >< > >> sponsor%253armisoluti...@verizon.net<sponsor%25253armisoluti...@verizon.net> > <sponsor%25253armisoluti...@verizon.net<sponsor%2525253armisoluti...@verizon.net> > > > >> > > >> >> >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:rmisoluti...@verizon.net <sponsor%3armisoluti...@verizon.net>< > sponsor%3armisoluti...@verizon.net <sponsor%253armisoluti...@verizon.net> > >< > >> sponsor%3armisoluti...@verizon.net<sponsor%253armisoluti...@verizon.net>< > sponsor%253armisoluti...@verizon.net<sponsor%25253armisoluti...@verizon.net> > > > >> >< > >> >> > >> sponsor%3armisoluti...@verizon.net<sponsor%253armisoluti...@verizon.net> > <sponsor%253armisoluti...@verizon.net<sponsor%25253armisoluti...@verizon.net> > >< > >> sponsor%253armisoluti...@verizon.net<sponsor%25253armisoluti...@verizon.net> > <sponsor%25253armisoluti...@verizon.net<sponsor%2525253armisoluti...@verizon.net> > > > >> > > >> >> >ARSlist: > >> >> >> "Where the Answers Are" > >> >> >> > >> >> > > >> >> > > >> >> > >> > _______________________________________________________________________________ > >> >> > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > >> >> > Platinum > >> >> Sponsor:rmisoluti...@verizon.net<sponsor%3armisoluti...@verizon.net>< > sponsor%3armisoluti...@verizon.net <sponsor%253armisoluti...@verizon.net> > >< > >> sponsor%3armisoluti...@verizon.net<sponsor%253armisoluti...@verizon.net>< > sponsor%253armisoluti...@verizon.net<sponsor%25253armisoluti...@verizon.net> > > > >> >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:rmisoluti...@verizon.net<sponsor%3armisoluti...@verizon.net>< > sponsor%3armisoluti...@verizon.net <sponsor%253armisoluti...@verizon.net> > >< > >> sponsor%3armisoluti...@verizon.net<sponsor%253armisoluti...@verizon.net>< > sponsor%253armisoluti...@verizon.net<sponsor%25253armisoluti...@verizon.net> > > > >> >ARSlist: > >> >> "Where the Answers Are" > >> >> > >> > > >> > > >> > _______________________________________________________________________________ > >> > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > >> > Platinum > >> Sponsor:rmisoluti...@verizon.net <sponsor%3armisoluti...@verizon.net>< > sponsor%3armisoluti...@verizon.net <sponsor%253armisoluti...@verizon.net> > >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:rmisoluti...@verizon.net <sponsor%3armisoluti...@verizon.net>< > sponsor%3armisoluti...@verizon.net <sponsor%253armisoluti...@verizon.net> > >ARSlist: > >> "Where the Answers Are" > >> > > > > > _______________________________________________________________________________ > > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > > Platinum > > Sponsor:rmisoluti...@verizon.net<sponsor%3armisoluti...@verizon.net>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:rmisoluti...@verizon.net<sponsor%3armisoluti...@verizon.net>ARSlist: > "Where the Answers Are" > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
