Hi Friends,

I have three columns A, B & C (Date Data Type) containing Dates in
following formats:

                      1/14/2008 10:45 AM

above format is for all three above columns within a table.

1.  Now I wish to contain C = A - B.  I mean substraction of A & B in to
C.  While doing so through programming (VBA), I am getting wrong results
in A.  Please help me if how I can do so and I need urget relpy on the
same.

Procedure that I am following is quite simple through VBAL:

        C.Value = A. Value - B.Value

I am writing this code in VBA for form to update values in Table.

However, results are correct.

=> The result should also be in 1/14/2008 08:12 AM format.

Looking forward for your reply at [EMAIL PROTECTED]
<mailto:[EMAIL PROTECTED]> .

I shall be highly thankful to you.

Regards,

Nik.



[Non-text portions of this message have been removed]

Reply via email to