[AccessD] Subtract Date/Time Fields

Vlad,

I don't have access to Access at the moment, but look up the DateDiff
method.

Bobby

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of ACTEBS
Sent: Tuesday, December 16, 2008 8:38 PM
To: access group
Subject: [AccessD] Subtract Date/Time Fields

Hi Everyone,
 
This is driving me to drink!!
 
How do you subtract 2 date/time values? eg. 17/12/2008 12:00:00   from
20/02/2009 19:40:00
 
All I am after is how many days, hours, minutes and seconds there are
between the 2 dates.
 
Anyone had any experience with this type of problem?
 
Thanks in advance...
 
Vlad