Dude, Time in Remedy is stored in seconds, and when you subtract the two and set that value to another time field, that is the result you would get as its the number of seconds since 1st Jan 1970 (epoch time)..
Set the difference to an integer field, which will be the number of seconds, and then create a function to read this value and convert it to days, hrs, mnts and seconds.. Joe ________________________________ From: kryptonboy22 <[email protected]> To: [email protected] Sent: Monday, July 13, 2009 3:37:42 AM Subject: Re: BMC Remedy: Subtract Date/Time 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 > <[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! _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are"
