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