Date Diff between two dates/times

[jmc014]

Hi,

I'm wondering if someonce could help me with a problem that I've been working on for a while.
I have 4 fields [Start_Date], [Start_Time], [End_Date] and [End_Time]. I'd like to know how I can implement the datediff funtion to calculate the total time
(either days or hours) elapsed beteen these four fields.

Can anyone push me in the right direction.
Thanks.

 

[SkipVought]

hi,

simply [end date-time] minus [start date-time]

Duration = ( [End_Date] + [End_Time] ) - ( [Start_Date] + [Start_Time] )

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[jmc014]

Thanks skip,

I see where your going, the results in your code only showin the date diff, not the date & time diff.
I mean, the time factor is not being taken into consideration.

JMC,

 

[dhookom]

Skip's expression will correctly return the duration down to the second. Formatting of the display may obfuscate the actual value. The result should be in "days" unit so 24 hours is 1.0. A day and a half is 1.5 is 36 hours.

Duane
Hook'D on Access
MS Access MVP

 

[SkipVought]

the time factor is not being taken into consideration

Huh? How did you arrive at that conclusion from the code that I posted?

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}