add a number of days onto a date

  • Thread starter Thread starter li c
  • Start date Start 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?
 
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?
Click to expand...

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