Kathy, You may want to put $Start Date$ into an Int field before you do the /3600.....but in general your setfield doesn't make allot of sense.
On Fri, Nov 8, 2013 at 8:55 AM, Kathy Morris <[email protected]> wrote: > ** > > ** > > I had created an active link to set a field Hours with ($End Date$ = > $Start Date$ /3600) on modify. > > The error message displays “incompatible data types for arithmetic > operation.” > > > > *From:* Action Request System discussion list(ARSList) [mailto: > [email protected]] *On Behalf Of *Reiser, John J > *Sent:* Thursday, November 07, 2013 3:27 PM > *To:* [email protected] > *Subject:* Re: Time Measurement > > > > ** > > Make that 3600 > > > > Thank you, > > --- > John J. Reiser > Remedy Developer/Administrator > > Senior Software Development Analyst > Lockheed Martin - MS2 > The star that burns twice as bright burns half as long. > Pay close attention and be illuminated by its brilliance. - paraphrased by > me > > > > *From:* Action Request System discussion list(ARSList) [ > mailto:[email protected] <[email protected]>] *On Behalf Of *Grooms, > Frederick W > *Sent:* Thursday, November 07, 2013 3:26 PM > *To:* [email protected] > *Subject:* EXTERNAL: Re: Time Measurement > > > > ** > > If you take and subtract 1 date from the other you will get total seconds > between them. Divide by 60 to get total hours. > > > > *From:* Action Request System discussion list(ARSList) [ > mailto:[email protected] <[email protected]>] *On Behalf Of *Kathy > Morris > *Sent:* Thursday, November 07, 2013 2:17 PM > *To:* [email protected] > *Subject:* Time Measurement > > > > ** > > Hi, > > > > In the midst of building workflow to translate the dates to hours. > > For example, I want to calculate the total hours between the “start date” > to the “end date” within a table. Any ideas on the best way to translate > this? I always struggle with the dates. > > > > > > > > _ARSlist: "Where the Answers Are" and have been for 20 years_ > > _ARSlist: "Where the Answers Are" and have been for 20 years_ > _ARSlist: "Where the Answers Are" and have been for 20 years_ > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
