Calculating difference between general dates

[Ray]

I have 2 TextBoxes, StartDate and EndDate and they are formatted as General
Date. I want to make a new TextBox which displays the difference between
StartDate and EndDate in days, hours and minutes.

Example: StartDate = 1/2/06 1:00:00 AM
EndDate = 1/3/06 5:30:00 PM

Desired Result 1: TextBox3 = 1 day, 16 hours and 30 minutes
or
Desired Result 2: TextBox3 = 40 hours and 30 minutes

Any suggestions?

 

[Wayne-I-M]

Hi Ray

Take a look at the excellent article by Allen Brown

http://allenbrowne.com/casu-13.html

 

[Matt]

Can you explain where and how this code should be entered into the Database?
I am having a simialr problem (Using Access 2003). I am trying to calculate
the difference between two General dates:

StartDate = 1/2/06 1:00:00 AM
EndDate = 1/3/06 5:30:00 PM

Thanks.

 

[Matt]

I am having a similar Problem...The article details how exactly I want to
have my answer formatted. Can you tell me where this code should be entered
into my database (Access 2003)

I am trying to calculate the difference between the data entered into text
boxes: Dateassigned and Datedue
Dateassigned = 7/2/08 1:00:00 AM
Datedue = 7/7/08 2:00:00 PM