quote:Originally posted by minhtri
In order for this to work, both textboxes must contain datatype Date/Time. If you put
Me.TextBox1 = Now()
You cannot have Me.Textbox2 = "14:2:20" because the quotes " tell me that the value is type TEXT (a string), not Date/Time. Enter it as a real time value. Then use DateDiff("n", Me.TextBox1, Me.TextBox2) for minutes or DateDiff("s", Me.TextBox1, Me.TextBox2) for seconds to get a difference.
Michigan Dept. of Environmental Quality, Air Quality Division