I am looking for help in creating a formula having nested IIf statements whose conditions rely on two date fields. One or the other of the date fields may be Null.
The formula I have come up with so far is:
=IIf(IsNull([Text1]),([EnrolledDate])+21,DateAdd("d",365,[Text1]))
In addition
If [Text1] is null and [EnrolledDate] is null the result should be null
This is working as far as the calculations are concerned but the form will display #Name? if the [EnrolledDate] field is null. Not all of the clients will ever be enrolled.
I would like to clean up the end user form view so that “#Name?” does not appear.
Any help would be appreciated.
The formula I have come up with so far is:
=IIf(IsNull([Text1]),([EnrolledDate])+21,DateAdd("d",365,[Text1]))
In addition
If [Text1] is null and [EnrolledDate] is null the result should be null
This is working as far as the calculations are concerned but the form will display #Name? if the [EnrolledDate] field is null. Not all of the clients will ever be enrolled.
I would like to clean up the end user form view so that “#Name?” does not appear.
Any help would be appreciated.
Last edited: