Hi all, I am using LibreOffice 3.3.2 on both Windows & Linux (depending on whether I'm at work or home).
I have a Base DB that tracks shift work, and want a query (or view) that calculates the total hours worked. I am experimenting with two variations of the shift table. Version #1 has: shift_start_date (DATE) | shift_start_time (TIME) | shift_end_date (DATE | shift_end_time (TIME) - a shift can start & end on different dates. Version #2 uses the DATETIME timestamp format: shift_start | shift_end I saw reference to the DATEDIFF (DATEDIFF(string, datetime1, datetime2) here: http://user.services.openoffice.org/en/forum/viewtopic.php?f=61&t=23563&start=0 This would seem to work with my Version #2 table, but it doesn't work for either table as I have attempted to deploy it: If I try: [code]DATEDIFF( 'mi', 'shift_alt_start', 'shift_alt_end' ) [/code] --- per the example from OpenOffice.org forum above I get a message that claims I *have* to use 'yyyy-mm-dd hh:mm:ss[.ffffffff]' Fair enough. I tried that exact format in the query (where 'mi' is) and using the yyyy-mm-dd hh:mm:ss format in my table field definitions. I get error messages anyway I try it. Can anyone help? Thanks! Don -- D.C. Parris, FMP, LEED AP O+M, ESL Certificate Minister, Security/FM Coordinator, Free Software Advocate https://www.xing.com/profile/Don_Parris | http://www.linkedin.com/in/dcparris GPG Key ID: F5E179BE -- Unsubscribe instructions: E-mail to [email protected] In case of problems unsubscribing, write to [email protected] 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
