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...
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

Copy previous record into form field 0
Display weeks from a Milestone 0
Split form 0
Text box contents not visible until exited 3
Open forms based on criteria 4
Dlookup - double booking 4
Query to return latest dates 5
How to return Max date or Null (if there is a Null present) 4

Top