Issue 1714 - edate function
Summary: edate function
Status: CLOSED FIXED
Alias: None
Product: porting
Classification: Code
Component: code (show other issues)
Version: 633
Hardware: PC Linux, all
: P3 Trivial (vote)
Target Milestone: ---
Assignee: daniel.rentz
QA Contact: issues@sw
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2001-09-25 00:43 UTC by charles
Modified: 2001-12-04 13:08 UTC (History)
1 user (show)

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


Attachments

Note You need to log in before you can comment on or make changes to this issue.
Description charles 2001-09-25 00:43:32 UTC
edate function does not work for a change of year, the example is edate(last cell;1) stops working at change of year. Workaround is to use 
DATE function (Date(year(last cell+45);month(last cell +45);1)-1
Comment 1 thomas.lange 2001-09-25 08:29:09 UTC
It's not the formula editor it's the spreadsheet.
Comment 2 niklas.nebel 2001-10-01 10:49:06 UTC
It's the getEdate function from the analysis add-in.
Comment 3 daniel.rentz 2001-10-12 10:48:35 UTC
The EDATE function works correctly now up to year 32767.
Fixed in SRC641G
Comment 4 oc 2001-12-04 13:08:12 UTC
Fixed and verified in OO641
Comment 5 oc 2001-12-04 13:08:26 UTC
.