• 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-2019 by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
Ideas, requests, problems regarding TWiki? Send feedback