Default date in a table value based on another date in that same table

[jmwebster91]

Hello, I'm Joe.



I have a database which is designed to send out automatic emails one year on from the purchase of an item to remind them to buy a service kit. As well as an email 5 years on to remind them to buy a refurbishment kit. I would like to be able to send a reminder email 10 days after each of these reminders.

So the total time after the order is placed is 1 year and 10 days.

This data is in a table called 'Full Data'

Order Date (Date/Time) - Default value " =Date "

Spares Follow Up Date (Date/Time) - Default value " =DateAdd('m',+12,Date()) "

Refurb Follow Up Date (Date/Time) - Default value " =DateAdd('m',+60,Date()) "


Trying to populate a field called "10DaySparesFollowUpDate"
my best guess:

=DateAdd('d',+10,[Spares Follow Up Date])


Many thanks
Joe

[ranman256]

the formula for a query , then:
DateAdd('d',375,[purchaseDate]) '1yr, 10 days
DateAdd('d',1835,[purchaseDate]) '5yrs 10 days

[jmwebster91]

the formula for a query , then:
DateAdd('d',375,[purchaseDate]) '1yr, 10 days
DateAdd('d',1835,[purchaseDate]) '5yrs 10 days

Thank you very much, this worked wonderfully.


Another thing, if iI want a query to find this day "=Date()" every year,

for instance today, the query would return all values with dates;

12/05/2016
12/05/2017
12/05/2018
12/05/2019 ... and so on

how could this be done in a query?