I am havgin trouble with writing this statement effectively
Timely 6 mo test: IIf(IsNull([FY 09 6 Mo due],”“,IIf(([FY 09 6 mo due]>=[6 Mo Received]),"Yes", IIf(([FY 09 6 mo due]<=[6 Mo Received]),"No")
I have FY 09 6 mo due as a date field that is automatically calculated based on a programs date. The 6 Mo Received field is a date field that is input by a user once a report is received. I am asking in this Timely 6 mo test field for it to automatically populate (using my conditiaonl statement) if the report is on time or not. I want this field to be null if there is no date in the 6 Mo Received field, to be Yes if the date indicates it was received on time, and No if it indicates it was received late.
I cant get all three conditions to work together. Any help?