Item6253 < Bugs

AppliesTo:	Component:	Priority:	CurrentState:	WaitingFor:	TargetRelease	ReleasedIn
Extension	SpreadSheetPlugin	Urgent	Closed		patch	4.3.2

$WORKINGDAYS is returning invalid results. For example when I use %CALC{$WORKINGDAYS($TIME(2009/03/07),$TIME(2009/03/12))}%

it returns 2 though the actual workingdays are 4. As I'm trying to use this in report generation I'm getting faulty reports.

-- TWiki:Main/BharathReddyMeka - 25 Apr 2009

Bug confirmed.

-- TWiki:Main.PeterThoeny - 26 Apr 2009

Any updates on this??

-- TWiki:Main.BharathReddyMeka - 08 May 2009

This is now fixed. Issue was an incorrect number of days if daylight savings time change happens between start date and end date. Download latest plugin from TWiki:Plugins/SpreadSheetPlugin.

As a workaround, add 3601 seconds to serialized day (each of start date and end date).

-- TWiki:Main.PeterThoeny - 10 May 2009

Hi Peter, Adding 3601 seconds seems to be not working. I have used the following syntax for CALC, but I still get the result as 2 instead of 4. %CALC{$WORKINGDAYS($TIMEADD($TIME(2009/03/07), 3601,),$TIMEADD($TIME(2009/03/12), 3601,))}%

Am I missing something here. Please suggest.

-- TWiki:Main.BharathReddyMeka - 11 May 2009

Sorry, I do not have the bandwidth to debug your case. Please update the plugin, which I have fixed and tested for you.

-- TWiki:Main.PeterThoeny - 11 May 2009

ItemTemplate
Summary	$WORKINGDAYS is returning invalid results
ReportedBy	TWiki:Main.BharathReddyMeka
Codebase	4.1.2
SVN Range
AppliesTo	Extension
Component	SpreadSheetPlugin
Priority	Urgent
CurrentState	Closed
WaitingFor
Checkins	TWikirev:18077 TWikirev:18078
TargetRelease	patch
ReleasedIn	4.3.2

Item6253: $WORKINGDAYS is returning invalid results

Item Form Data

Edit Form Data

Detail