gheyman
Well-known Member
- Joined
- Nov 14, 2005
- Messages
- 2,347
- Office Version
- 365
- Platform
- Windows
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
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