• Do not register here on develop.twiki.org, login with your twiki.org account.
• Use View topic Item7848 for generic doc work for TWiki-6.1.1. Use View topic Item7851 for doc work on extensions that are not part of a release. More... Close
• Anything you create or change in standard webs (Main, TWiki, Sandbox etc) will be automatically reverted on every SVN update.
Does this site look broken?. Use the LitterTray web for test cases.

Item6253: $WORKINGDAYS is returning invalid results

Item Form Data

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

Edit Form Data

Reported By:
Applies To:
Current State:
Waiting For:
Target Release:
Released In:


$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

Summary $WORKINGDAYS is returning invalid results
ReportedBy TWiki:Main.BharathReddyMeka
Codebase 4.1.2
SVN Range

AppliesTo Extension
Component SpreadSheetPlugin
Priority Urgent
CurrentState Closed

Checkins TWikirev:18077 TWikirev:18078
TargetRelease patch
ReleasedIn 4.3.2
Edit | Attach | Watch | Print version | History: r9 < r8 < r7 < r6 < r5 | Backlinks | Raw View |  Raw edit | More topic actions
Topic revision: r9 - 2010-05-29 - PeterThoeny
This site is powered by the TWiki collaboration platform Powered by PerlCopyright © 2008-2024 by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
Ideas, requests, problems regarding TWiki? Send feedback