Howdy Listers!
I am working with a customer to "validate" that our production AR
System server environment is DSTC-compliant and encountered some
problems with the business time calculation functions.
I have a form that I’ve created, “DSTC_Test”, which contains three
fields aside form the normal “core” fields:
Start Time
Stop Time
Duration (Seconds)
I created a filter, “DSTC_CalcTimeDifference_200”, which fires on
Submit and Modify events if the ‘Start Time’ and ‘Stop Time’ fields
contain a value. It sets the ‘Duration (Seconds)’ field equal to the
difference in time (expressed in seconds). This is accomplished by a
Set Fields action that sets the ‘Duration (Seconds)’ field equal to
the result of the following command:
$PROCESS$ Application-Bus-Time-Diff "$StartTime$" "$StopTime$"
“24HrsTag” “24HrsTag”
I submitted four records to the “DSTC_Test” form. The test cases are
described below. I tested the difference in time over the daylight
savings time changes that will occur in 2007 (test cases 1 & 3). I
also tested, for reference purposes, the difference in time during
the DST periods for last year (test cases 2 & 4).
Test Case 1
The difference in time between 12:00 AM and 6:00 AM on March 11th, 2007.
Expected Result: 5 hours
Test Case 2
The difference in time between 12:00 AM and 6:00 AM on April 2nd, 2006.
Expected Result: 5 hours
Test Case 3
The difference in time between 12:00 AM and 6:00 AM on November 4th,
2007.
Expected Result: 7 Hours
Test Case 4
The difference in time between 12:00 AM and 6:00 AM on October 29th,
2006.
Expected Result: 7 Hours
Here are the results that I saw. Just to make sure I wasn't off my
rocker, I wrote a quick Java program to perform the same
comparisons. Those worked flawlessly and as expected. The
Application-Business-Time-Diff function... well, that's quite a
different story.
Remedy ARS 6.3 Patch 20
Pass/Fail
Description
Start Time
Stop Time
Duration (Seconds)
Duration (Hours)
Test Case 1
3/11/07 12:00 AM
3/11/07 6:00 AM
21,600
6
F
Test Case 2
4/2/06 12:00 AM
4/2/06 6:00 AM
25,200
7
F
Test Case 3
11/4/07 12:00 AM
11/4/07 6:00 AM
21,600
6
F
Test Case 4
10/29/06 12:00 AM
10/29/06 6:00 AM
18,000
5
F
Java 5.0 Patch 11
Description
Start Time
Stop Time
Duration (Seconds)
Duration (Hours)
Test Case 1
3/11/07 12:00 AM
3/11/07 6:00 AM
18,000
5
P
Test Case 2
4/2/06 12:00 AM
4/2/06 6:00 AM
18,000
5
P
Test Case 3
11/4/07 12:00 AM
11/4/07 6:00 AM
25,200
7
P
Test Case 4
10/29/06 12:00 AM
10/29/06 6:00 AM
25,200
7
P
Table 1: Test Case Results - Remedy Business Time Versus Java
Has anyone else seen this?
Derek
Derek Berube <[EMAIL PROTECTED]>
Wildstar Technologies, LLC.
1453 Riverview Run Lane
Suwanee, Georgia 30024
(678) 229-1475 - Office
(678) 229-1476 - FAX
(404) 444-5283 - Mobile
http://www.wildstartech.com/
AIM Handle: BerubeDB
Jabber: [EMAIL PROTECTED]
MSN Messenger: [EMAIL PROTECTED]
Yahoo! Messenger: derekberube
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers
Are"
