Smokeeater
Registered User.
- Local time
- Today, 14:00
- Joined
- Jan 15, 2009
- Messages
- 58
I have three date fields. [DateA], [DateB], [DateC].
[DateC] is a calculated field in my query, that adds 2 years to [DateA], and it works fine via this criteria:
DateC_2: DateAdd("yyyy",2,[DateA])
However, [DateA] is only used one time, and then all follow up activities are defined in [DateB].
What I would like to do is maintain the current the 2 year addition for [DateA] in [DateC], until such time [DateB] is used, and then it would reset the date in [DateC] based on the date in [DateB] + 2 years.
Sort of like:
Criteria 1: [DateC] = [DateA] + 2 Years from date entered, until
Criteria 2: [DateC] = [DateB] + 2 Years from date entered
I tried this, but it returned date value of -1.
DateAdd("yyyy",2,[DateA]) or DateAdd("yyyy",2,[DateB])
Thanks in advance for any assistance
[DateC] is a calculated field in my query, that adds 2 years to [DateA], and it works fine via this criteria:
DateC_2: DateAdd("yyyy",2,[DateA])
However, [DateA] is only used one time, and then all follow up activities are defined in [DateB].
What I would like to do is maintain the current the 2 year addition for [DateA] in [DateC], until such time [DateB] is used, and then it would reset the date in [DateC] based on the date in [DateB] + 2 years.
Sort of like:
Criteria 1: [DateC] = [DateA] + 2 Years from date entered, until
Criteria 2: [DateC] = [DateB] + 2 Years from date entered
I tried this, but it returned date value of -1.
DateAdd("yyyy",2,[DateA]) or DateAdd("yyyy",2,[DateB])
Thanks in advance for any assistance