adding two date fields

L

Laila

Hi,
My database deals with the biomedical equipment.
i have in my form a date field called date of installation and i have
another number field called time of warranty, and i want a to display in my
form a calculated date field called warranty expired date which is equal the
sum of the date of installation of the equipment and the time of warranty....
Can you help?....thanks...
 
R

Rick Brandt

Laila said:
Hi,
My database deals with the biomedical equipment.
i have in my form a date field called date of installation and i have
another number field called time of warranty, and i want a to display
in my form a calculated date field called warranty expired date which
is equal the sum of the date of installation of the equipment and the
time of warranty.... Can you help?....thanks...

See DateAdd() function in help.
 
Top