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