Copy the date from otherfield if IsNull!

[cap.zadi]

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"

[andy49]

If (isnull(actualstartdate)= true,[schedulestartdate], [actualstartdate])

[cap.zadi]

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])

[andy49]

Sorry try iif

[cap.zadi]

Hi

Same error still exists.

[pbaldy]

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.