Hi,
I need help to organize the fields as below:
Fields:
ScheduleStartDate
ActualStartDate
Requirement: If the "ActualStartDate" fields is null or date is not entered yet then it shall show/copy the date of "ScheduleStartDate"
Hi,
I need help to organize the fields as below:
Fields:
ScheduleStartDate
ActualStartDate
Requirement: If the "ActualStartDate" fields is null or date is not entered yet then it shall show/copy the date of "ScheduleStartDate"
If (isnull(actualstartdate)= true,[schedulestartdate], [actualstartdate])
Dear Sir
Thanks but i applied it on my form and its giving error #Name? and the expression turns into:
=If(IsNull([actualstartdate])=True,[schedulestartdate],[actualstartdate])
Sorry try iif
Hi
Same error still exists.
The same syntax but with IIf should work. Make sure the field names are correct, and also that there's no textbox with the same name as the fields.