Minddumps
Registered User.
- Local time
- Today, 14:55
- Joined
- Jul 5, 2011
- Messages
- 73
Hi everyone,
As an FYI for anyone looking for this, here's my situation. I have some dates I needed to calculate in relation to the event date (for my horseblanket) and 3 of which MUST land on a Tuesday. For example I needed to know when to send out invitations for this event, I needed to set the date for my 60 days before the event call, and also for 30 days and 10 days--of which these calls always occur on a Tuesday.
Hopefully that make sense. So before I show you the code, for the 30 days, I just counted backwards for the date of my event 30 and continued until I got to the Tuesday. Repeated for the others.
Here's the code:
Hope this helps someone else trying to accomplish similar tasks!
As an FYI for anyone looking for this, here's my situation. I have some dates I needed to calculate in relation to the event date (for my horseblanket) and 3 of which MUST land on a Tuesday. For example I needed to know when to send out invitations for this event, I needed to set the date for my 60 days before the event call, and also for 30 days and 10 days--of which these calls always occur on a Tuesday.
Hopefully that make sense. So before I show you the code, for the 30 days, I just counted backwards for the date of my event 30 and continued until I got to the Tuesday. Repeated for the others.
Here's the code:
Code:
Invitation: DateAdd("d",-88,[NHRADate])
Code:
60 Day Call: DateAdd("d",-60,[NHRADate])
Code:
30 Day Call: DateAdd("d",-32,[NHRADate])
Code:
10 Day Call: DateAdd("d",-11,[NHRADate])Hope this helps someone else trying to accomplish similar tasks!
