Access Expression/formula question

[gheyman]

Whats wrong with this formula? it will not let me enter it. But I am not seeing where the problem is.

Submitted_Late: IIf([[PDIR Completed] Is Null,"",IIf([PDIR Completed] > [PDIR Due Date] ,DateSerial(Year([PDIR Submission Date]),Month([PDIR Due Date])+1,1)-1),"")

I am checking first to see if I have a date in the PDIR Completed field. If I do then I want to see if that date is greater than the date in the PDIR Due Date Field. If it is, then I want to do a "Eomonth" formula to enter the PDIR Due Date

 

[Joe4]

For one thing, you have double square brackets:
Submitted_Late: IIf([[...

 

[gheyman]

Submitted_Late: IIf([PDIR Completed] Is Null,"",IIf([PDIR Completed] > [PDIR Due Date] ,DateSerial(Year([PDIR Submission Date]),Month([PDIR Due Date])+1,1)-1,""))

Thanks Joe4

 

[Joe4]

So, did that solve the issue, or is there still other problems with the formula?