Hi there,
I'm currently setting up a database to automatically send emails to customers on the anniversary of a purchase.
Currently, the follow up date is populated on entry to the database by the criteria:
=DateAdd('m',+12,Date())
Thinking about this logically, the weekend that has just passed i.e 21/05/2016 - 22/05/2016 could have been weekdays in the previous year
and therefore the query that looks for last year's orders will not find them as the query criteria is as follows
DateAdd("yyyy",-1,Date())
DateAdd("yyyy",-2,Date())
DateAdd("yyyy",-3,Date())
and so on.
If there is a way on a monday, to include the two prior dates as well as monday's date
the dates of orders that would be returned instead of:
23/05/2015
23/05/2014
23/05/2013 .... etc
would instead return the dates
21/05/2015
22/05/2015
23/05/2015
21/05/2014
22/05/2014
23/05/2014
21/05/2013
22/05/2013
23/05/2013
..... etc
Please ask for clarification if any of this seemed unclear, i'm new to posting on forums
Many Thanks
Joe