Support Forum

[fbourget]

Hello,

I create a script to fill Spent Time:

Code: Select all

long updateDate = message.getTime().getTime().getTime();
  long lastUpdateDate = message.getTask().getUpdatedate().getTime().getTime();
  long spentTime = (updateDate - lastUpdateDate) / 1000;
  message.setHrs(spentTime);

I customize spent time format in Day Hours Minutes Seconds.
When spent time is small amount, display is OK. When spent time amount is big, display is wrong.
Ex:
spent time in database = 4228974
spent time display = 146 days 7 hours 10 minutes 43 seconds

Could you, please, help.
Thanks and regards

[admin]

Can you post there some specific example, with timestamps, sceenshots, etc ?

[fbourget]

Hello,

This is an example:
updateDate = 2011/04/14 2:57:30 PM
lastUpdateDate = 2011/02/24 3:14PM
calculated spent time (in seconds) = (updateDate - lastUpdateDate) / 1000 = 4228974
displayed spent time = 146 days 6 hours 42 minutes 54 seconds

real spent time = 48 days 22 hours 42 minutes 54 seconds

I think TrackStudio computes on working day of 8 hours = 4228974 /(8*3600) = 147 days rounded
Is it ? how can I transform my calculation to obtain the real spent time?

Thanks and regards

[Petr]

That is ok. You just need set time in setTime not setHrs.
setHrs is used for set hours.
In your code as like

Code: Select all

long updateDate = message.getTime().getTime().getTime();
long lastUpdateDate = message.getTask().getUpdatedate().getTime().getTime();
long spentTime = (updateDate - lastUpdateDate) / 1000;
message.setTime(spentTime); // this


[fbourget]

Hello,

There is an error message:
"The method setTime(Calendar) in the type SecuredMessageTriggerBean is not applicable for the arguments (long)".

Thanks and regards.

[Petr]

Code: Select all

Calendar#getTime()#getTime();