Calculating date/time variables between two dates
Posted on 2010-11-12
I did a search and found some examples but none that are working and none that are giving me what I want. Just a basic DateDiff really isn't working for me either.
I have a StartDate and an EndDate in a query. The hard data from the query could look like this:
11/11/2010 5:00:00 AM 11/12/2010 12:01:05 PM
I need to display the difference between these two fields as:
1 day, 7 hours, 1 minute, and 5 seconds