Hi :)
The "integer" function in Access rounds down. So that 72.9999 would also be
given as =72. Clearly in most cases (such as when looking at cash prices) the
usual answer you would want it to give would be 73, which is what Base appears
to be giving. Annoyingly it is also 'incorrectly' rounding up for a value that
'should' be being given as 72.
In Access i tended to add 0.5 before doing the integer thing in order to force
it to round correctly. In Base perhaps just do a -1? or a -0.5? Of course i
found the "Round" function in Access after writing the equations but i don't
think you want to risk rounding up.
On a side note i find it interesting that up until legal drinking age children
tend to say things like "I'm nearly 9" or "I'm 12, ('soon')" but after legal
drinking age people try to down-play their age. Also we say "I'm ... years
old" rather than "I'm ... years young".
Also i heard that some cultures respect their elders, partly for just surviving
that long, but also for the acquired wisdom that a person is likely to have
acquired. Surely we should celebrate our age?
Regards from
Tom :)
--- On Thu, 16/2/12, [email protected] <[email protected]> wrote:
From: [email protected] <[email protected]>
Subject: [libreoffice-users] Fw: LibreO-Base is lying about my age!
To: "Users LibreOffice" <[email protected]>
Cc: [email protected]
Date: Thursday, 16 February, 2012, 11:40
--- Alkuperäinen viesti ---
Aihe: LibreO-Base is lying about my age!
Päiväys: 15.2.2012 17:46
Lähettäjä: Pertti Rönnberg [[email protected]]
Kopio: Pertti Rönnberg [[email protected]]
Dear all of you,
First an opinion - correct me if wrong!
I've got the idea that this is kind of a help-desk where every LibreO user can
both ask for help and give info about problems related to LibreO's components.
Without any bad feelings afterwards!
Referring to the irrelevant "debates" recently and also my own experiences some
weeks ago I would say that a real expert has the ability to concentrate on the
question as-it-is and give a relevant answer -- he has knowledge enough to
understand that there are no silly or wrong questions.
Every question has its reason - and every question is valuable because it
indicates that there may be something to repair or do better in LibreO.
There is a truth in quality systems (e.g. ISO 9000): "without identifying the
weaknesses there is no development".
_And now to my contribution to make LibreO better:_
I need to calculate in LO-Base the difference between an 'olddate' and today
expressed in whole years (no decimals)
The main procedure seems to be the same in LO-Base and OOo as in MSAccess.
The function I placed in the query field is (ref. also to guides in LO & OOo):
datediff('year',"table1"."olddate",current_date) or
datediff('year',"olddate",current_date)
When I inserted my birthdate (2.11.1939) in 'olddate' my computer states that I
am 73 - I'm NOT, I'm still only 72!
The correct result is 72,225 years; and the desired answer without decimals 72.
> I got the same wrong result (73) both in LO-Base and in OOo-Base
> the wrong result is not logical - it can not be a rounding up, nor is it a
>result of an 'int()'-function
> if I replaced 'year' with 'dd' or 'mm' or 'yy' the function works -- but
when replaced 'year' with 'yyyy' the function stopped working (why - 'year'
and 'yyyy' ought to be equal!)
> the query field does not accept the expression "int(datediff(..etc))"
> the date-format is equal (finnish - see above) in every relevant field
> my OS is Windows7Professional/32Bit
I also tried the formula /year(current_date - "olddate")/ but the query did not
accept it as a valid expression - can I put that formula anywhere else?
Anyone there who can tell me how I shall get the LO-Base to be honest?
Regards
Pertti Rönnberg
-- For unsubscribe instructions e-mail to: [email protected]
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
--
For unsubscribe instructions e-mail to: [email protected]
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
