On 10/04/2012 06:29 AM, Mark Stanton wrote: > And, as a "stylistic" suggestion, don't use a separate field for > transaction year, calculate it from transaction date. The reason is > that you've created a new classs of issue for yourself by doing this, > keeping two fields in step. > > In general it's best to store basic data and calculate subsidiary > data from it, don't store subsidiary data. > > Regards > Mark Stanton > One small step for mankind... > > > The function is Year(name) = year. For best results store the date in yyyy-mm-dd format,
Typical use is Select column list >From table list Where Year(column) = yyyy AND month = mm There are other date/time functions available. -- Jay Lozier jsloz...@gmail.com -- 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: 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