add a number of days onto a date

  • Thread starter Thread starter Shazza
  • Start date Start date
S

Shazza

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?
 
Set the Control Source of an unbound text box to:

= [DateField] + 40

More specific would be to use DateAdd:

=DateAdd("d",40,[DateField])

You can use DateAdd to add or subtract other intervals such as month, year,
minute, etc.

Note that you should not store the calculation result, but rather display it
as needed.

Substitute the field you identified as "a previous field" for [DateField] in
the above expressions.
 
If you did a search in this forum on the subject I'm sure you would find many
items to help you. If the field is a valid date/time field, add an unbound
field to your form or report and in the Control Source put
=[DateReceived]+40, or if you're using a datasheet or just want to build it
in a query you could make a query and add a column like
Reply:[DateReceived]+40 and use the query for your source.
 
Back
Top