[AccessD] A2K: Time diff calcs

Darren DICK d.dick at uws.edu.au
Wed Sep 15 06:06:06 CDT 2004


Hi Arthur
Many thanks for the tip and I agree. Store the seconds format when needed.
In the relevant table should the data type be Integer?

Have a great day

Darren



-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Arthur Fuller
Sent: Wednesday, 15 September 2004 5:34 AM
To: 'Access Developers discussion and problem solving'
Subject: RE: [AccessD] A2K: Time diff calcs


IMHO you should always store time differences in seconds rather than any
higher denomination, then leave the formatting of same to the front end.
That way, IMO, your back-end data is always correct (and easily calculated),
and you can postpone the formatting until the front end is right, confident
that your data in the back-end is correct.

Just my $.02.

Arthur

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Darren DICK
Sent: Tuesday, September 14, 2004 8:25 AM
To: AccessD List
Subject: [AccessD] A2K: Time diff calcs


Hello all
I want to calculate then insert into a table the duration of a users logon
in HOURS and MINUTES In the logon table the default value for the logon
field is Now() and is captured at...You guessed at logon. I then run a query
that updates the Logoff field to Now() once the user answers YES to loggin
off. The theory being there will be a difference even if it is only 5 or 10
seconds. Unless some clown plays with the clock after loggin on --- but
forget all that :-))

Both logon and logoff fields data types in the Logon Table are General Date
(01/01/2004 15:45:25PM)

So a user logs on at say...14/09/2004 10:08:45 PM and then logs off at
say...14/09/2004 10:10:55 PM

The time logged on = 2 mins and 10 secs but how do I calculate that?

I have udsed DateDiff but with no success...
DateDiff("Short Time",[LogonTimeAndDate],Now())
DateDiff("mm",[LogonTimeAndDate],Now())
DateDiff("nn",[LogonTimeAndDate],Now()) etc etc

Many thanks in advance

Darren


-- 
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

-- 
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com




More information about the AccessD mailing list