Fun on a date

[Guest]

Ok,

First let me thank you for all of your help.
I have a process that has a start time and an end time that needs to be
recorded.

I was thinking that I would have two buttons. Each button would insert a
Date/time into an appropriate field. I was thinking I would do a setvalue to
insert the =Now(). This would give me a system value for both the start and
end time. If I wanted to find out how much time had elapsed I was thinking I
would subtract one from the other.
My questions are:
Anyone have a better idea?
What format do I use to display the difference in time?

Thnaks

 

[Jeff Boyce]

Joe

Consider saving yourself some "real estate". Instead of two buttons, you
could code in the control's DoubleClick event to add Now() to the field. Do
this with each field.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Guest]

The format for the difference will be based on your granularity. Do you want
days or seconds elasped time. Use DateDiff function.