| DateTimeSpan.days [message #70216] |
Tue, 30 August 2005 13:47  |
Eclipse User |
|
|
|
Originally posted by: birgit.dippelreiter.promac.at
Hi,
in our report we are working with the DateTimeSpan Function
"DateTimeSpan.days" to get the duration of processes.
We noticed that some durations are correct and other not, but only one day
difference.
We work with the following expression:
DateTimeSpan.days(row["UEBERGABEDATUM"],row["AKTLEISTUNGDAT "])
Both Datafields are Datefields.
Here are some examples:
StartDate (dd/mm/yyyy) - EndDate (dd/mm/yyyy) - Duration (BIRT) - Duration
(recalculated)
15/09/1997 - 04/11/1997 - 50 - 50
16/02/1998 - 07/03/1999 - 384 - 384
29/02/2000 - 06/03/2001 - 371 - 371
14/04/2000 - 30/07/2002 - 837 - 837
17/11/2003 - 28/10/2004 - 345 - 346
17/11/2003 - 07/12/2004 - 386 - 386
17/03/2003 - 11/05/2005 - 785 - 786
Do we do anything wrong?
Or is it a rounding problem?
Or can anyone help us?
With best regards,
Birgit Dippelreiter
|
|
|
| Re: DateTimeSpan.days [message #70384 is a reply to message #70216] |
Wed, 31 August 2005 11:25  |
| Eclipse User |
|
|
|
Originally posted by: birgit.dippelreiter.promac.at
Hi!
We solved the problem. The Function "DateTimeSpan.days" cuts the decimal
places and doesnŽt round.
Now we calculate the DateSpan with the method "getTime()" and a simple
computation.
With best regards,
Birgit Dippelreiter
|
|
|
Powered by
FUDForum. Page generated in 0.03370 seconds
] 
Search
Help
Register
Login
Home
