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

Am 28.01.2012 23:54, Dan Lewis wrote:

> Does someone know how to create a table using SQL or perhaps even a
> macro that would create the date table with enough entries for the
> number of years that this database might need?
>
> --Dan

Use a spreadsheet where the DATE function in combination of MOD, INT and 
others can generate arbitrary sequences.
Select your sequence, copy, select the table icon in the main database 
window and paste (or drag the cells onto the icon). Follow the import 
wizard.


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