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]> > > > >> > > >> >> >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-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]> > > > >> >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-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]> > >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-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]>ARSlist: > "Where the Answers Are" > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are"
