[libreoffice-users] Re: LO Base - calculating dates

Am 28.01.2012 23:54, Dan Lewis wrote:
>   This might not be the most elegant solution:
>
> I created a table of dates (01/01/2012 to 12/31/2013) calling it "Date".
> Then I wrote a query using  the following SQL:
>       SELECT "Date" FROM "Date" WHERE DATEDIFF('dd',:start_date,"Date")
> =180 OR DATEDIFF('dd',:start_date,"Date") = 365

IF and only IF we are talking about the infamous HSQLDB 1.8 which is 
embedded in the so called "Base document", the following trick works 
with years but not nesecarily with months and days:
SELECT CAST(YEAR("Date")+1||'-'|| 
CASEWHEN(MONTH("Date")<10,'0','')||MONTH("Date") ||'-'|| 
CASEWHEN((DAY("Date"))<10,'0','')||(DAY("Date")) AS DATE)AS"Calc Date" 
FROM "Table"



--
For unsubscribe instructions e-mail to: users+help@global.libreoffice.org
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