Issue 109892 - Wrong example for function EDATE() in help document of Calc
Summary: Wrong example for function EDATE() in help document of Calc
Alias: None
Product: documentation
Classification: Unclassified
Component: Online help (show other issues)
Version: DEV300m84
Hardware: All All
: P3 Trivial (vote)
Target Milestone: AOO PleaseHelp
Assignee: AOO issues mailing list
QA Contact:
: 113131 (view as issue list)
Depends on:
Reported: 2010-03-07 10:50 UTC by new_ooo3
Modified: 2017-05-20 11:27 UTC (History)
3 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---


Note You need to log in before you can comment on or make changes to this issue.
Description new_ooo3 2010-03-07 10:50:08 UTC
I find a wrong example for function "EDATE" in help description of Calc.

****** [ Help description for function "EDATE" ] *****
The result is a date which is a number of months away from the start date. Only
months are considered; days are not used for calculation.

EDATE(StartDate; Months)
StartDate is a date.
Months is the number of months before (negative) or after (positive) the start date.

What date is one month prior to 3.31.2001?

=EDATE(3.31.2001;-1) returns 2.28.2001. <--"This line is incorrect."

If I would use "=EDATE(3.31.2001;-1)" in Calc,I get "error509".
I think it is necessary to add the double quotes with first parameter.
So,I proposal the following;

Current(incorrect) :  =EDATE(3.31.2001;-1) returns 2.28.2001.
Change (correct)   :  =EDATE("3.31.2001";-1) returns 2.28.2001.

My kind member invest above issue, we know the description of the different
expressions of OOo3.x and OOo2.x.
I am happy you will consider the issue and correct the help discription.
Comment 1 Uwe Fischer 2010-07-14 08:14:14 UTC
*** Issue 113131 has been marked as a duplicate of this issue. ***
Comment 2 Uwe Fischer 2010-07-14 08:16:17 UTC
changing component and owner
Comment 3 Uwe Fischer 2010-07-14 08:17:17 UTC
Calc function Help will be updated following the integration of CWS hccalc01
Comment 4 Uwe Fischer 2011-01-21 12:29:06 UTC
changed target
Comment 5 Brian 2013-04-28 18:00:14 UTC
The EDATE() function itself appears not to work on OS X 10.8.3
The help may be correct --both online and off-- if only the function worked.

=EDATE(3.31.2001;-1) returns Err:509
=EDATE("3.31.2001";-1) returns #VALUE!
Comment 6 Marcus 2017-05-20 11:27:39 UTC
Reset assigne to the default "".