• 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.
Compare: 
%CALC{$FORMATTIME($TIMEADD($TIME(1 Jun 2007), 1, month), $year $mon $day)}%

%CALC{$FORMATTIME($TIMEADD($TIME(1 Jul 2007), 1, month), $year $mon $day)}%

When run: 2007 Jul 01

2007 Jul 31

So $TIMEADD adds 31 days not a month.

I reported this last week, but the bug report seems to have been blanked out? I hope I'm not duplicating this.

reassigning to spreadheet plugin

CC

This is per spec - one month in SpreadSheetPlugin is 30.42 days.

Line 758 in Calc.pm reads: 

       $value *= 3600*24*30.42 if( $scale =~ /^mon/i );  # FIXME: exact calc

Closing.

-- TWiki:Main.SteffenPoulsen - 22 Dec 2007

ItemTemplate
Summary TimeADD not prcessing Month correctly
ReportedBy TWiki:Main.ChrisHogan
Codebase 4.1.2
SVN Range TWiki-4.1.2, Thu, 19 Jul 2007, build 14438
AppliesTo Extension
Component SpreadSheetPlugin
Priority Normal
CurrentState No Action Required
WaitingFor

Checkins

TargetRelease n/a
ReleasedIn

Edit | Attach | Watch | Print version | History: r4 < r3 < r2 < r1 | Backlinks | Raw View |  Raw edit | More topic actions
Topic revision: r4 - 2007-12-22 - SteffenPoulsen
 
This site is powered by the TWiki collaboration platform Powered by PerlCopyright © 2008-2020 by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
Ideas, requests, problems regarding TWiki? Send feedback