FYI,
Originally Posted by
arbucklemw
<snip>
Request Date field (which will be previously populated by the user on a form)
Due Date field
IIf([txtCarrierType]="CARRIER", [dteUpgradeRequestDate] DateAdd(+45), (+30))
I've tried variations of the above expression, and have googled my head off to no avail. What I want the calculation to do is to produce results that show the Due Date with 45 days added to the Request Date if the text field contains "Carrier" and 30 days added to the Request Date if either of the other 2 text options are present.
<snip>
The syntax for the DateAdd function is
DateAdd(interval, number, date)
interval = "d" (days)
number = 45 or 30
date = dteUpgradeRequestDate
So the formula you were trying to create would be
Code:
=IIf([txtCarrierType] = "CARRIER",DateAdd("d", 45, [dteUpgradeRequestDate]), DateAdd("d", 30, [dteUpgradeRequestDate]))