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]> >> >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-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]>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-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] ARSlist: "Where the Answers Are"
