Bulala
05-17-2008, 03:32 AM
I have a so easy problem but i cant solve it. I have 3 fields, begintime, and how long service extends, third textfield should be result of these 2 fields.
Like begintime + extendtime = result like 10.00 + 00.30 = 11.30 and so on...all fields are in short time.
tehNellie
05-20-2008, 06:39 AM
There's a strong argument not to store calculated information in a separate field, just perform the calculation when you need to.
But if your two fields are both currently date/time then you can use the function datefdiff() to get a simple difference between the two dates in years, months, days, hours, minutes or seconds.
namliam
05-20-2008, 07:16 AM
There's a strong argument not to store calculated information in a separate field,
That is an understatement... Simply do not store calculated values....
But if your two fields are both currently date/time then you can use the function datefdiff() to get a simple difference between the two dates in years, months, days, hours, minutes or seconds.
Adding and datediff??
If the fields are dates, simply add them:
StartTime + Duration
Will return the endtime...