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

2012-01-30 Thread Mark Stanton
Use MySQL with PERIOD_ADD(P,N) to add N months to the date P Mark Stanton One small step for mankind... -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more:

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

2012-01-28 Thread Mark Stanton
I think (without actually having tried it) that just adding numbers to a date field will do what you want, so your date field+365 should give you the year in advance date Mark Stanton One small step for mankind... -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org

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

2012-01-28 Thread Andrew Douglas Pitonyak
On 01/28/2012 05:42 AM, Mark Stanton wrote: I think (without actually having tried it) that just adding numbers to a date field will do what you want, soyour date field+365 should give you the year in advance date A side note of caution. Not every year has 365 days, so tricks are usually used