<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body>
<p>
<div>
<b><a class="bz_bug_link
bz_status_NEW "
title="NEW - Maximum date value in Base is 27/06/9957"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=40575#c28">Comment # 28</a>
on <a class="bz_bug_link
bz_status_NEW "
title="NEW - Maximum date value in Base is 27/06/9957"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=40575">bug 40575</a>
from <span class="vcard"><a class="email" href="mailto:iplaw67@tuta.io" title="Alex Thurgood <iplaw67@tuta.io>"> <span class="fn">Alex Thurgood</span></a>
</span></b>
<pre>(In reply to Eike Rathke from <a href="show_bug.cgi?id=40575#c23">comment #23</a>)
<span class="quote">> Internal tools' class Date representation is now (since 5.2) capable to
> handle dates between -32768-01-01 and 32767-12-31, including conversion
> from/to css::util::Date
>
> However, connectivity/source/commontools/dbconversion.cxx still has its own
> date implementation that probably interferes here. Someone familiar with
> Base should check what the consequences were if that was eliminated and the
> common tools Date routines be used. My guess is that various database
> related things can't cope with years > 9999 because year might be stored
> using 4 characters, so some extra handling will still be needed there.</span >
@Eike :
Does any of this affect the DateAdd() function in LOBasic ?
Someone has just reported on the German M-L that the help is incorrect when
describing how to enter the string for the date (indeed, it does seem wrong,
but that is tangential to what is to follow):
Sub example_dateadd
MsgBox DateAdd("m", 1, 31012004) &" - "& DateAdd("M", 1, 31012005)
End Sub
Using the above:
- if use double quote characters around the date string, I get other error
messages, such as "unsuported type", or "unsupported operation" depending on
which way I type the string separators (dots or slashes);
- if I use as in the above example, i.e. no quotes around what is essentially
an integer, I get a MsgBox that displays "31/0/1/32767 - 31/01/32767" which is
obviously incorrect.
Is this behaviour related to the changes in date representation support of
css::util::Date or does DateAdd() rely on the Database date functions ?
Should I open a separate report for this ?</pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>