[libreoffice-users] Calculating Time in Base Queries

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 users+help@global.libreoffice.org
In case of problems unsubscribing, write to postmaster@documentfoundation.org
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