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: [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
