On Jan 28, 2006, at 1:47 PM, [EMAIL PROTECTED] wrote:
I want to save a time to a data an array of items, and save it to a
database.
There is a time field in the db, and a date data type, but suppose
I open the
data base and want to get the times out of it, what kind of place
do I put
them?
I would like to do :
Employee.punchinTime <--- database record time field
PS please look at my DB 2006 question. Thats holding me up big
time. I don't
mind paying for a web article even if it will solve this problem. I am
checking all the docs but nothing helps. Is there any explanatory
release for RB2006
other than that huge long list of bug fixes?
Personally I would do a full Date-Time for every employee in and
out. What is really the most important is not the time punch but the
difference between the in and out. This is most easily calculated by
using the Date.TotalSeconds property:
Dim secondsAtWork As Double
Dim employeeTimeIn As Date
Dim employeeTimeOut As Date
// code here to assign employeeTimeIn and employeeTimeOut from
database
secondsAtWork = employeeTimeOut.TotalSeconds -
employeeTimeIn.TotalSeconds
_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>
Search the archives of this list here:
<http://support.realsoftware.com/listarchives/lists.html>
