DateDiff for days and time
-
Hello, I want to be able to calculate how long an event took. The user will enter the data using a datetimepicker for the start date, and when the event ends enter the stop date in a datetimepicker. Does the datetimepicker capture the time when the date was set in one of these controls? I have been using the dateDiff to calculate. However, it only gives me the difference between to dates but not the actual time it was set. For example 26/2/2007 14:00 started finisted at 28/2/2007 10:00 The total time would be 1 Day 4 hours (working 9 to 5pm) Can anyone have any good ideas on how to calculate this, Many thanks, Steve
-
Hello, I want to be able to calculate how long an event took. The user will enter the data using a datetimepicker for the start date, and when the event ends enter the stop date in a datetimepicker. Does the datetimepicker capture the time when the date was set in one of these controls? I have been using the dateDiff to calculate. However, it only gives me the difference between to dates but not the actual time it was set. For example 26/2/2007 14:00 started finisted at 28/2/2007 10:00 The total time would be 1 Day 4 hours (working 9 to 5pm) Can anyone have any good ideas on how to calculate this, Many thanks, Steve
Try using the 'DATE DIFFERNECE' function ..... DDiff...
-
Try using the 'DATE DIFFERNECE' function ..... DDiff...