adding two date fields

G

Guest

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...
Click to expand...

See DateAdd() function in help.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Text box contents not visible until exited 3
If not executing 4
Display Label based on Date 1
displaying generated date in a form 3
Date Add Function on Forms 1
how to save a calculated field in a form to a table 3
Change color on date field in form for re-certification 1
Conditional format of a control 2

Top