add a number of days onto a date

L

li c

Please could you advise if there is a formula or method which can be used to
add a certain number of days to a date in a previous field. For example our
Subject Access requests must be replied to within 40 days, so we would like
the column after that of the "Date Received" to be automatically updated
with
a date 40 days later. Is there an easy way to achieve this?
 
J

John W. Vinson

Please could you advise if there is a formula or method which can be used to
add a certain number of days to a date in a previous field. For example our
Subject Access requests must be replied to within 40 days, so we would like
the column after that of the "Date Received" to be automatically updated
with
a date 40 days later. Is there an easy way to achieve this?

If it's always 40 days, the field should NOT EXIST in your table. Instead you
should store only the Date Received in a table field; you can use a Query with
a calculated field

DateDue: DateAdd("d", 40, [Date Received])

This calculated field can be displayed but not edited.

If the due date is flexible and the 40 days is just a suggestion or a default,
you can calculate it on a form - post back if so.
 

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

Top