In Microsoft Access, I need an expression that will add 15 days to a date that is already on the record.?

Question

I have a receiving log in Microsoft Access, and I need to add 15 days to the day received into a separate "projected date out" field. How do I do that? Is there an expression I can use?

Answer 1

Another option: If you build a query based on your log table you can add a new field in an empty columnn of the query grid (named "projected date out") and make its value equal to your "day received" field plus 15. Then, when you run the query, you'll see the new date but it's not "stored" in your table but you can see it whenever it's run or printed - plus, you can use this new field just like any other field in a table - in forms and reports. However, the field isn't modifiable in a form as it is a calculated result.

Here's what you might have in the "Field" row of your query grid assuming you have an existing field called "day received" and want to name your new field "projected date out":

projected date out: [day received]+15

Answer 2

DateAdd("d",15,yourdate)