[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: [libreoffice-users] Fw: LibreO-Base is lying about my age!
- Subject: Re: [libreoffice-users] Fw: LibreO-Base is lying about my age!
- From: Pertti Rönnberg <firstname.lastname@example.org>
- Date: Sun, 19 Feb 2012 14:38:16 +0200
- To: Users LibreOffice <email@example.com>
Dennis, Jorge and Drew - thanks!
The functions rounddown() and yearfrac() are both new to me; I shall study and try them.
I think that I have got my problem solved - I'm satisfied.
Not necessary, but of pure interest I should like to know what is wrong either in the writing of Andreas' solution or elsewhere - when copy-pasted into a db (LO-Base v.3.4.5) a pop-up window says first "column 'Select ..(etc)' is unknown" and then "syntax error".
The Andreas' version was (directly copy-pasted here):
DATEDIFF( 'mm', "BirthDate", CURRENT_DATE ) / 12
- CASE WHEN MONTH("BirthDate")=MONTH(CURRENT_DATE) AND
DAY("BirthDate")>DAY(CURRENT_DATE) THEN 1 ELSE 0 END AS "Age"
On 18.2.2012 3:21, Dennis E. Hamilton wrote:
You should display =Now() to see what date format is being understood. If it is dd/mm/yyyy, you haven't had your 73rd birthday yet, according to LO.
Also, dividing by 365 for such a long span is suspicious.
Assuming that you want actual calendar time and the same formulas used by Calc work, try something like (using my birthday):
where DATE( ) is used to avoid formatting confusion and the YEARFRAC( ) actual-days basis is used to compute the fractional years from the first date to the second.
This got my age (73) correctly in LibreOffice 3.3.2 Calc.
From: jorge [mailto:firstname.lastname@example.org]
Sent: Friday, February 17, 2012 16:38
Subject: Re: [libreoffice-users] Fw: LibreO-Base is lying about my age!
I suggest to do this:
Input in A3:
El jue, 16-02-2012 a las 13:40 +0200, email@example.com escribió:
--- 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 [firstname.lastname@example.org]
Kopio: Pertti Rönnberg [email@example.com]
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&
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
> 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
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
Anyone there who can tell me how I shall get the LO-Base to be honest?
For unsubscribe instructions e-mail to: firstname.lastname@example.org
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
|Re: [libreoffice-users] Fw: LibreO-Base is lying about my age!||Dan Lewis <email@example.com>|
|[libreoffice-users] Fw: LibreO-Base is lying about my firstname.lastname@example.org|
|Re: [libreoffice-users] Fw: LibreO-Base is lying about my age!||jorge <email@example.com>|
- Prev by Date: [libreoffice-users] Re: Problem with vertical scroll bar in LibreOffice Writer 3.5 for Mac OS X
- Next by Date: [libreoffice-users] Footnotes and Endnotes are hidden together with reference numbers!!!
- Previous by thread: Re: [libreoffice-users] Fw: LibreO-Base is lying about my age!
- Next by thread: Re: [libreoffice-users] Fw: LibreO-Base is lying about my age!