Well...I just 'fixed' this...by doing a setfield of the Date/Time field into a tmp Char field, then using that as the start time instead of the actual date/time field...this has evened out my business hour calculations so that two screens, right next to each other are giving out different values...very weird 2 hour difference
-----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Opela, Gary L CTR USAF AFMC 72 CS/SCBAH Sent: Friday, September 26, 2008 2:39 PM To: [email protected] Subject: Re: Business Time Weirdness LJ, the epoch you have in second action, 1167751252, is equal to 1/2/2007 9:20:52 AM, which would confirm what you are seeing. The only thing I can think of, is that since you are dealing with a table, it must be performing the calculation at the database level or server level, which would not utilize timezone. It is odd though, since you are using an AL, I would expect it to still adjust for your TZ, but I guess since the value is in a table, it is having to query the database whenever you perform your calculation, and doesn't adjust for the TZ. I call it a bug in my book. Disclaimer: My whole hypothesis on what is going on my be right or wrong. Gary -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of LJ Longwing Sent: Friday, September 26, 2008 3:32 PM To: [email protected] Subject: Business Time Weirdness ** Ok...I have two different AL's performing the same function, with slightly different input. The first is using information in a column representation of a Date/Time field as the start time, then takes that output and /3600 to give you the business hours elapsed. <ACTL> Process: Application-Bus-Time-Diff "1/2/2007 8:20:52 AM" "9/26/2008 2:14:00 PM" "Holiday Schedule" " Weekday Schedule " <ACTL> Duration (900109526) = 12952388 <ACTL> 1: Set Fields <ACTL> Duration (900109526) = 3597 The second action is actually on the form that contains the Date/Time field...same scenario...but this time I notice it uses the epoch value instead of the 'local timezone converted value' like the column display of the information is. If I do a conversion of 1167751252 I'm told it equals "1/2/2007 8:20:52 AM" (in my time zone) <ACTL> Process: Application-Bus-Time-Diff "1167751252" "9/26/2008 2:14:29 PM" "Holiday Schedule" " Weekday Schedule " <ACTL> Duration (Business Hours) (900601624) = 12945217 <ACTL> 1: Set Fields <ACTL> Duration (Business Hours) (900601624) = 3595 The difference between these two calculated values is 7171, which is not quite what I would call a 'round' number as far as time is concerned. Both values are calculated using the 7.1 Patch 3 user tool against a 7.1 Patch 3 server. I'm in Mountain Time Zone....has anyone experienced anything similar and know what's going on? __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ ____________________________________________________________________________ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
