How to calculate total minutes from two dates/times in a query? 2

[mrtauntaun]

I have two dates and times, example 12/10/2005 1:29:22 PM and 1/6/2006 4:13:10 PM
How can I have a query take these two dates and return the total number of minutes?

 

[DotNetGnat]

use datediff()

-DNG

 

[AlexMidd]

DateDiff("n",FirstDate,SecondDate)

Have fun! )

Alex Middleton

 

[mrtauntaun]

The two dates are generated from another query, and there will be a big list of them. Can I use datediff to use that data? Something akin to Datediff ("n",[Field1},[Field2])? Im not familiar with the datediff command.

 

[AlexMidd]

Yes, that sytax should work.

Have fun! )

Alex Middleton

 

[PHV]

Another way:
TotalMinutes: Int(1440*([Some date field]-[Another date field]))

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886