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